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

1 vote153 views1 answer
How to set up a trigger in sql
SQL
0 vote149 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
9 votes135 views1 answer
Mysql check date range
SQL
5 votes164 views1 answer
Oracle nls parameters
SQL
1 vote180 views1 answer
Homebrew install mysql
SQL
0 vote139 views1 answer
Date datatype in livesql
SQL
2 votes150 views2 answers
Mysql limit
SQL
0 vote138 views1 answer
Sql server check whether column has same equal values
SQL
0 vote160 views1 answer
Php select data from mysql database without column name
SQL
16 votes167 views1 answer
Sql comment'
SQL