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 votes359 views1 answer
Oracle select first 10 rows
SQL
1 vote373 views1 answer
Generate random data postgresql
SQL
0 vote362 views1 answer
Drop CHECK constraint sql
SQL
0 vote323 views1 answer
Mariadb list tables
SQL
7 votes338 views1 answer
Mysql unsafe update
SQL
0 vote442 views1 answer
Sql doesn't contain
SQL
3 votes385 views1 answer
Postgresql if null then 0
SQL
0 vote410 views1 answer
Postgres docs /copy metacomand
SQL
0 vote369 views1 answer
Date on SQL
SQL
0 vote377 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL