/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 vote155 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote157 views1 answer
How many rows affected in sqllite
SQL
0 vote158 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
18 votes148 views6 answers
Create table mysql
SQL
0 vote159 views1 answer
Sql getdate minus 1 day without time
SQL
11 votes154 views3 answers
Python sqlite3 create table if not exists
SQL
19 votes146 views6 answers
Laravel sql query
SQL
1 vote161 views1 answer
Trim leading zeros in sql
SQL
0 vote166 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote148 views1 answer
Stored procedure function relation
SQL

Share