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 vote369 views1 answer
Mysql strict_trans_tables
SQL
0 vote365 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote336 views1 answer
Oracle call a function in a insert statement
SQL
4 votes297 views1 answer
Oracle sleep
SQL
0 vote425 views1 answer
Python get backup of sql
SQL
12 votes360 views2 answers
Find duplicates mysql column
SQL
1 vote565 views2 answers
Sql unique rows
SQL
3 votes348 views1 answer
RENAME table pl sql
SQL
0 vote345 views1 answer
Postgresql inline table
SQL
3 votes357 views3 answers
Update join
SQL