[go: up one dir, main page]
Scribd
Upload
9 views1 page

Question Set

The document outlines a set of queries related to an employee database. It includes tasks such as finding employee locations, updating salaries by department, tracking project assignments, and analyzing work hours. Additionally, it involves creating views and classifying employees based on job titles and performance metrics.

Uploaded by

vikrammadhad2446
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views1 page

Question Set

The document outlines a set of queries related to an employee database. It includes tasks such as finding employee locations, updating salaries by department, tracking project assignments, and analyzing work hours. Additionally, it involves creating views and classifying employees based on job titles and performance metrics.

Uploaded by

vikrammadhad2446
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Employee DB Question Set

1. Find out the working location of each employee


2. Create Salary column & update the salaries for each department as below
D1 → 40K
D2 → 30K
D3 → 55K
D4 → 60K
D5 → 75K
D6 → 100K
D7 → 125K
D8 → 130K
D9 → 150000
3. Find which project the employee is working on.
4. Find out the total hours worked on each project by each employee.
5. Find those employees who have not worked on any of the projects.
6. Find the maximum hours worked on which project.
7. Create a view which stores employees' department names & their respective salaries.
8. Create a view which stores the projects allocated to each employee
9. Find the employees who have worked more than 20 hours on a single project.
10. Create a query that classifies employees based on their job titles as 'Manager','Developer', or
'Other'.
11. Retrieve a list of employees who worked on multiple projects.
12. Retrieve each employee’s total hours worked on projects, and show the rank of each employee
based on total hours worked.
13. List all employees whose total hours worked are above the overall average using subquery.
14. Update the Employees table by changing the job_title of all employees working in the
'Engineering' department to 'Senior Developer', except for those who are 'Manager' or 'HR
Specialist'.
15. Find out which department has the highest average employee salary.

You might also like