/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 vote405 views1 answer
Traccar mysql
SQL
0 vote385 views1 answer
Mysql 3 months ago
SQL
0 vote338 views1 answer
Sql change default collation to utf8
SQL
0 vote352 views1 answer
Add colum date in sql
SQL
2 votes345 views2 answers
Sqlite_busy: database is locked
SQL
1 vote351 views2 answers
Sql groub by count
SQL
1 vote370 views1 answer
Oracle select row max date
SQL
18 votes350 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote363 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote383 views1 answer
Ajouter une clé etrangere mysql
SQL

Share