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 free

Explore the full course: Zero To Hero

Loading lesson…