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 vote110 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
4 votes111 views1 answer
Create column mysql terminal
SQL
0 vote110 views8 answers
Convert sql query to linq online
SQL
7 votes118 views2 answers
Postgres concat
SQL
0 vote102 views1 answer
Print boolean in plsql
SQL
0 vote104 views1 answer
Sql developer connect to sql server
SQL
0 vote101 views1 answer
Add timestamp column to existing table ms sql server
SQL
4 votes101 views1 answer
Sql delete multiple conditions
SQL
4 votes104 views2 answers
Oracle unlock user
SQL
0 vote146 views1 answer
Placements hackerrank solution
SQL