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 vote115 views2 answers
Csv into data postgres
SQL
0 vote126 views1 answer
Second Step in installing SQL workbench
SQL
0 vote142 views1 answer
Sql quary stuf
SQL
0 vote131 views1 answer
Install package for sqlserver in asp.net core
SQL
2 votes113 views1 answer
Ssh mysql port forwarding
SQL
1 vote121 views1 answer
Oracle duration between timestamps
SQL
3 votes70 views4 answers
Show columns from table
SQL
0 vote132 views1 answer
Postgresql replace html tags from string
SQL
0 vote112 views1 answer
Nth max in my sql
SQL
8 votes187 views1 answer
Oracle search code in packages
SQL