I was given two tables one was employee table and other was a department table. On basis of these tables I was asked few questions :-
1. Write a query to find the max salary of any employee .
2. Write a query to find the max salary of any employee in all the department , grouped by department .
3. Write a query to find all the departments where sum of salaries of the employees is less than a particular sum.
4. Write a query to find all the departments where total number of employees is less than 3.
5. Write a query to select all the salaries of the employees grouped by department where the departments were arranged based on the sum of the salaries in that department.