Sql average

Sql count

/*COUNT(column_name) will return the number of rows from the column 
that are not NULL*/
SELECT COUNT(column_name)
FROM table_name;

/*COUNT(*) will return the number of rows from the table*/
SELECT COUNT(*)
FROM table_name;

Sql average

SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;

How to find average in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

Similar codes

-1 vote147 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
5 votes182 views1 answer
How to get all dates in a month in oracle
SQL
1 vote209 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote202 views1 answer
Import mysql dump database command line linux
SQL
1 vote206 views1 answer
Oracle activate job
SQL
0 vote234 views1 answer
How to find unique element in sql
SQL
0 vote252 views1 answer
Liquibase update row
SQL
0 vote222 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote209 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote193 views1 answer
Get create table query existing table mysql
SQL