display the employees whose salary is less than average salary code example

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

SELECT * FROM EMPLOYEES
WHERE SALARY > 10000;

Example 2: display the employees whose salary is less than average salary

select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);