Count the total salary deptno wise where more than 2 employees exist.

Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?

Select all records from emp table where deptno = 30 and sal > 1500.

Count number of managers (MGR column) and their salary in emp table.