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

6 votes334 views1 answer
What is where clause in sql
SQL
9 votes344 views4 answers
SQL Date Format
SQL
19 votes345 views5 answers
Date between in mysql
SQL
0 vote398 views1 answer
Dockerfile example for Django
SQL
28 votes362 views6 answers
Foreign key
SQL
5 votes335 views1 answer
How to check nls format in oracle
SQL
0 vote318 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote350 views1 answer
Postgresql not in
SQL
0 vote345 views1 answer
Sql server roles and users
SQL
0 vote323 views1 answer
Mysql_error replacement
SQL