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 vote241 views1 answer
How to update sql server version
SQL
11 votes251 views5 answers
Update table from another table mysql
SQL
5 votes244 views3 answers
MySql get fields of table
SQL
0 vote240 views2 answers
Mysql row_number() example
SQL
2 votes271 views3 answers
Postgres json to string
SQL
0 vote279 views1 answer
Calculer pourcentage mysql
SQL
-1 vote212 views10 answers
Delete Query in SQL Server
SQL
12 votes228 views1 answer
Create column sql server
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
7 votes241 views1 answer
Sql server convert string to date
SQL