Write SQL queries

1) Find the employee id, name, and work location of highly paid employees in each

department

2) Remove departments without employees.

3) Find employees who are working as department's manager in London, UK.

4) Find city with maximum number of departments in each country.

5) Create a new table that contains following information of each employee:

employee id, full name, job title, monthly salary, department name

6) Which employees of sales department are not granted any commission?

7) Show managers and their employees in each department.

8) Show employees who has worked in IT department during last five years.

9) Find employees who are working in Tokyo, Japan.

10) Grant an increment of 5000 to those employees who have served the department for more

than two years.