/SQL/Find below average salary in sql

Find below average salary in sql

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

0

FIND AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

0

FIND ABOVE AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEES
WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Similar codes

0 vote187 views1 answer
Look at running processes redshift
SQL
4 votes180 views1 answer
Find tables with column name in sql
SQL
14 votes178 views3 answers
Alter foreign key
SQL
0 vote174 views1 answer
Mysql find missing values
SQL
1 vote163 views1 answer
Delete triger pl pg sql
SQL
9 votes183 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote171 views1 answer
Mysql workbench indent formatting
SQL
0 vote216 views1 answer
Mysql workbench not showing schemas
SQL
1 vote180 views1 answer
Grab all records from one table to another oracle sql
SQL
4 votes182 views1 answer
Create table if not exist in sqlite
SQL

Share