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;
You might also like to view...
QuickTime software comes standard with the ____ operating system.
A. Windows B. Apple C. Linux D. Unix
The ________ checks a workbook for personal data
Fill in the blank(s) with correct word
OpenSSL contains a minimal CA application that ships with the toolkit.
Answer the following statement true (T) or false (F)
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)