Consider the tables PROJECT (Pname, Pnumber, Plocation) and WORKS_ON(ESSN, Pno, Hours). The query to retrieve the project number, project name and number of employees who work on that project is:
1
Select Pnumber, Pname, COUNT(∗) from PROJECT, WORKS_ON where Pnumber = Pno;
2
Select Pnumber, Pname, COUNT(∗) from PROJECT, WORKS_ON GROUP BY Pnumber, Pname;
3
Select Pnumber, Pname, from PROJECT, WORKS_ON where Pnumber = Pno GROUP BY Pnumber, Pname;
4
Select Pnumber, Pname, COUNT(∗) from PROJECT, WORKS_ON where Pnumber = Pno GROUP BY Pnumber, Pname;
5
Question Not Attempted