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 vote207 views2 answers
Sql update multiple tables
SQL
0 vote197 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote199 views4 answers
Rownum in sql
SQL
2 votes197 views1 answer
Anonymous block plsql
SQL
0 vote205 views3 answers
Mysql delete if not in another table
SQL
3 votes219 views2 answers
Update part of a string in mysql
SQL
0 vote200 views1 answer
Sql server convert date to weekday
SQL
0 vote233 views1 answer
Psql initialization
SQL
0 vote193 views1 answer
Mysql drop multiple tables at once
SQL
0 vote224 views2 answers
Mysql where in maintain order group_concat
SQL