SQL ONLY- Given Tables- Employee (EmployeeID, FirstName, LastName, Address) Department (DeptNo, DepartmentName, City) DepartmentEmployee(DeptNo, EmployeeID, Position) Project (ProjectNo, ProjectName, DeptNo) Project Team (...

50.1K

Verified Solution

Question

Programming

SQL ONLY-
Given Tables-
Employee (EmployeeID, FirstName, LastName,Address)
Department (DeptNo, DepartmentName, City)
DepartmentEmployee(DeptNo, EmployeeID,Position)
Project (ProjectNo, ProjectName, DeptNo)
Project Team ( ProjectNo, EmployeeID, Role)
MAKE THE QUERY FOR-
1. List the name and position of all the employee who works inthe (DeptNo = â€˜22Câ€™).
2. List the total number of employees in each department forthose departments with more than 5 employees.
3. List the project number, project name and the number ofemployees who worked on each project role.

Answer & Explanation Solved by verified expert

4.1 Ratings (863 Votes)

Answer 1Select eFirstNameeLastNamedePosition from Employee e join DepartmentEmployee de on deEmployeeID eEmploeeID where deDeptNo 22C order by eFirstName This query will See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member