02.Sql_3 - eshan3101/DataBase-Architech GitHub Wiki

1.Write a query to display employee names and their department names.

2.Display employee name, job title, and department name for all employees.

3.List all employees who do not belong to any department.

4.Write a query to show department names along with the city they are located in.

5.Display employee name, manager name, and department name.

6.List all employees who work in the same department as their manager.

7.Show employees whose salary is greater than their manager’s salary.

8.Display department name and the number of employees in each department.

9.Write a query to show employees and their job grades based on salary range (assume job grades table exists or simulate using CASE).

10.List all departments, including those with no employees.

11.Display employees hired after their manager was hired.

12.Show employee name, department name, country name, and region name.

13.Write a query to find employees working in the ‘Sales’ department along with their location

14.List employees whose department is located in the same city as their manager’s department.

15.Display department name, average salary, and maximum salary in each department.

16.Write a query to show employees who do not have a manager.

17.Display job title and total salary paid for each job role.

18.List employees working in departments located in the United States.

19.Write a query to display employees and their previous job history (use JOB_HISTORY table).

20.Display employees who changed jobs within the same department