For each project on which more than two employees worked, list the project number, project name, and the number of employees who work on that project.
What will be an ideal response?
SELECT p.projNo, projName, COUNT(empNo)
FROM Project p, WorksOn w
WHERE p.projNo = w.projNo
GROUP BY p.projNo
HAVING COUNT(empNo) >2;
Computer Science & Information Technology
You might also like to view...
A business can use ________ statement to create a line chart that shows income and expenses and the projected break-even point
A) a profit and loss B) an estimated income C) a break-even D) a summary
Computer Science & Information Technology
Which virus component is present in all viruses and is responsible for locating new files, disk space, or RAM to infect?
a. Search routing b. Infection routine c. Payload routine d. Trigger routine
Computer Science & Information Technology