How to find average in 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;

How to find average in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

Above average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

Similar codes

4 votes199 views2 answers
Mysql alter table set column unique
SQL
2 votes187 views2 answers
Install sqlalchemy
SQL
0 vote203 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
34 votes196 views6 answers
Sql change data type
SQL
0 vote198 views1 answer
On sql table data exists
SQL
0 vote189 views1 answer
Mysql add comment to column
SQL
8 votes187 views2 answers
Phpmyadmin default password
SQL
0 vote195 views1 answer
Mariadb number format
SQL
0 vote212 views1 answer
Postgresql find biggest table
SQL
18 votes190 views2 answers
Sql inner join
SQL