Q10-a

MCQMarks unknown

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:

(A)

SELECT ename FROM employees WHERE eno IN (SELECT eno FROM working GROUP BY eno HAVING COUNT(*)= (SELECT COUNT(*) FROM projects))

(B)

SELECT pname FROM projects WHERE pno IN (SELECT pno FROM projects MINUS SELECT DISTINCT pno FROM working);

Loading…