Average sql

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

0 vote275 views1 answer
Price-colour
SQL
9 votes324 views3 answers
Sql delete where in
SQL
0 vote246 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote283 views1 answer
Drop unique
SQL
0 vote295 views1 answer
Mysql get only the field names in a table
SQL
-1 vote250 views1 answer
Mysql if example
SQL
0 vote291 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote278 views1 answer
Power query case when
SQL
0 vote298 views1 answer
Sql query to get contact form 7 fields
SQL
3 votes305 views3 answers
Mysql declare variable
SQL