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 = 10 or 40.

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

How can we display all the employees grouped together on the basis of deptno and sal in descending order?