salary calculator code example
Example: display the employees whose salary is less than average salary
select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);
select * from EMPLOYEE where sal < (select avg(emp_sal) from EMPLOYEE);