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

-1 vote167 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
4 votes183 views1 answer
Mysql query first character
SQL
1 vote217 views2 answers
Laravel jwt generate token
SQL
1 vote194 views1 answer
Sqlalchemy order by descending
SQL
0 vote184 views2 answers
Drop tables from local table database postgres
SQL
0 vote185 views1 answer
Str_to_date sql server
SQL
1 vote176 views1 answer
Load sql into mamp
SQL
15 votes177 views2 answers
How to know the username of postgresql
SQL
13 votes184 views1 answer
Sql join 3 tables on id
SQL
1 vote174 views1 answer
Oracle create index if not exists
SQL