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

0 vote308 views1 answer
Report in database
SQL
2 votes647 views1 answer
Oracle virtual column
SQL
0 vote340 views1 answer
Mysql sum per week
SQL
0 vote286 views1 answer
Parsing float to int in mysql
SQL
1 vote322 views1 answer
Group_concat max length mysql
SQL
0 vote337 views10 answers
Sql statement checker corrector
SQL
0 vote298 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote299 views1 answer
Mysql set boolean default value
SQL
0 vote301 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote293 views1 answer
Mysqldump don't drop table
SQL