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

4 votes171 views3 answers
Postgres drop all tables
SQL
-1 vote158 views1 answer
How to Activate the database
SQL
0 vote180 views1 answer
Mariadb hours between two dates
SQL
1 vote150 views1 answer
Postgres left join
SQL
2 votes148 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote177 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
5 votes150 views6 answers
In operator sql
SQL
0 vote174 views1 answer
Get first monday of month sql
SQL
0 vote128 views1 answer
Mysql percentage of total
SQL
0 vote157 views1 answer
Mysql into outfile with headers
SQL