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 vote144 views1 answer
Python connect microsoft sql server
SQL
0 vote137 views2 answers
Search stored procedures
SQL
2 votes156 views1 answer
Sql count having
SQL
1 vote237 views1 answer
Sql injection
SQL
1 vote145 views1 answer
Mysql last year
SQL
6 votes149 views3 answers
What is where in sql
SQL
24 votes139 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
1 vote126 views2 answers
Sql example query
SQL
6 votes154 views2 answers
Mysql 1 day ago
SQL
0 vote152 views1 answer
How we can perform acid Operations in sql with examples
SQL