get all employee of salary if more than in sql code example

Example 1: get all employee of salary if more than in sql

SELECT * FROM EMPLOYEES
WHERE SALARY > 10000;

Example 2: find below average salary in sql

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