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

8 votes135 views1 answer
Sql remove leading spaces
SQL
0 vote141 views3 answers
Duplicate row mysql
SQL
0 vote144 views2 answers
How to find max and min salary in sql
SQL
0 vote137 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
2 votes137 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote147 views2 answers
Dumping sql table
SQL
44 votes208 views6 answers
Rename command in sql
SQL
0 vote145 views1 answer
Codigo crear tablas sql server
SQL
1 vote146 views1 answer
Delete specific row in sql
SQL
0 vote164 views1 answer
Mysql best varchar length size
SQL