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

6 votes106 views1 answer
Allsource oracle
SQL
0 vote103 views3 answers
Above average salary in sql
SQL
11 votes101 views5 answers
How to install sqlite3 python
SQL
0 vote102 views2 answers
Oracle sql for each row
SQL
0 vote103 views1 answer
How to insert a uniqueidentifier in sql
SQL
3 votes107 views1 answer
Make a field auto_increment mysql
SQL
0 vote104 views1 answer
Sql server change schema of a table
SQL
2 votes114 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote105 views1 answer
How to check event scheduler status mysql
SQL
0 vote109 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL