Write sql query to display the project name


Problem

Employee (empNo, firstName, lastName, address, DOB, sex, position, deptNo)
Department (deptNo, deptName, mgrEmpNo)
Project (projNo, projName, deptNo)
WorksOn (empNo, projNo, hoursWorked)
Dependent (empNo, Dependent_name, Sex, Bdate, Relationship)

Write SQL query to display the Project Name and the average number of hours clocked by employees that work for the project offered by department number 12, 21, or 24. Order the results in the increasing order of the average and rename the column as AvgHoursWorked. (hint: use the keyword IN)

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write sql query to display the project name
Reference No:- TGS03262107

Expected delivery within 24 Hours