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...

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

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