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 vote314 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote279 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
1 vote269 views2 answers
Difference between in and between in sql
SQL
0 vote275 views1 answer
Python mysql executemany
SQL
1 vote275 views1 answer
Return size of tables in mysql
SQL
7 votes328 views2 answers
Sql remove duplicates based on column
SQL
0 vote257 views1 answer
Count column of tables psql
SQL
0 vote320 views1 answer
Mariadb cast to int
SQL
0 vote279 views1 answer
Order by with where clause in mysql
SQL
0 vote278 views1 answer
Sql get month and year from date
SQL