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

7 votes396 views3 answers
Sql update where id
SQL
-2 votes346 views1 answer
Group functions in sql
SQL
3 votes348 views4 answers
Stop MySQL
SQL
0 vote377 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes352 views3 answers
How to get second highest salary in each department in sql
SQL
6 votes388 views2 answers
Foreign key sqlite3 python
SQL
0 vote348 views1 answer
Oracle job class
SQL
4 votes390 views6 answers
List all tables in postgres
SQL
0 vote344 views1 answer
How to execute stored output to csv files
SQL
0 vote336 views1 answer
Google sheets filter rows above current cell
SQL