get all employee of salary if more than in sql
snippet in sql

get all employee of salary if more than in sql

user5213

SELECT * FROM EMPLOYEES
WHERE SALARY > 10000;

find below average salary in sql

user8557

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