Consider the following relational database: employees (eno, ename, address,…
PYQ GATE 1990
Consider the following relational database:
employees (eno, ename, address, basic-salary)
projects (pno, pname, nos-of-staffs-allotted)
working (pno, eno, pjob)
The queries regarding data in the above database are formulated below in SQL. Describe in ENGLISH sentences the two queries that have been posted:
SELECT ename
FROM employees
WHERE eno IN
(SELECT eno
FROM working
GROUP BY eno
HAVING COUNT(*) = (SELECT COUNT(*) FROM projects))SELECT pname
FROM projects
WHERE pno IN
(SELECT pno FROM projects
MINUS
SELECT DISTINCT pno FROM working);Sign up free to check your answer
Sign up freeLoading lesson…

