What does the following query return?
SELECT Pnumber, Pname, COUNT (*)
FROM PROJECT, WORKS_ON
WHERE Pnumber = Pno
GROUP BY Pnumber, Pname
HAVING COUNT (*)>2;
The relational schemas are PROJECT(Pname, Pnumber, Plocation, Dnum) and WORKS_ON(Essn, Pno, Hours).
1
It retrieves the project number, the project name and the number of employees who work on the project.
2
It retrieves the project number and the project name of the employees who work on the project where for each project more than two employees work.
3
It retrieves the project number, the project name and the number of employees who work on the project where for each project more than two employees work.
4
It retrieves the project number and the number of employees who work on the project where for each project more than two employees work.