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 vote309 views1 answer
First mysql
SQL
0 vote294 views1 answer
Create duplicate table in postgresql
SQL
2 votes343 views2 answers
Mysql add hours to time field
SQL
1 vote308 views1 answer
Mysql pretty date format
SQL
0 vote349 views1 answer
Cannot pip install mysqlclient
SQL
0 vote382 views1 answer
Dockerfile example for Django
SQL
0 vote271 views1 answer
Denied
SQL
0 vote333 views2 answers
Disadvantages of stored procedures sql
SQL
1 vote324 views3 answers
How to truncate foreign key constraint table
SQL
0 vote332 views1 answer
Mysql to get column name in database
SQL