Repository navigation
02.Sql_3
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
2.Checking IP
3.seconf way to check IP
4.opening 2nd VM
5.doing settings in 2nd VM & pitting the IP address manually
6.Checking IP address in 2nd machine
7.checking connections in both the VM
8.setting environment
9.creating listners
10.starting listener
