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 vote310 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote336 views1 answer
Csv to sqlite python
SQL
0 vote351 views1 answer
Psql check table fields
SQL
1 vote315 views2 answers
How to enable error squiggles in vs code
SQL
3 votes313 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote288 views1 answer
Metada in sql
SQL
0 vote307 views1 answer
C# datetime to sql server datetime
SQL
2 votes304 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote318 views1 answer
How to order result of subquery in select
SQL
3 votes317 views2 answers
Sql select data from last week
SQL