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...
QuickTime software comes standard with the ____ operating system.
A. Windows B. Apple C. Linux D. Unix
Computer Science & Information Technology
The ________ checks a workbook for personal data
Fill in the blank(s) with correct word
Computer Science & Information Technology
OpenSSL contains a minimal CA application that ships with the toolkit.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
You can add an effect to a table by clicking the Effects button on the ____.
A. (TABLE TOOLS DESIGN tab | Effects group) B. (TABLE TOOLS LAYOUT tab | Table Styles group) C. (TABLE TOOLS DESIGN tab | Table Styles group) D. (TABLE TOOLS LAYOUT tab | Effects group)
Computer Science & Information Technology