SQL

SELECT P1.address
FROM Cinema P1

Single correct

• AWHERE P1.capacity >= All (select P2.capacity from Cinema P2)
• BWHERE P1.capacity >= Any (select P2.capacity from Cinema P2)
• CWHERE P1.capacity > All (select max(P2.capacity) from Cinema P2)
• DWHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)

SELECT empName
FROM employee E
WHERE NOT EXISTS (SELECT custId
                  FROM customer C
                  WHERE C.salesRepId = E.empId
                  AND C.rating <> 'GOOD');

Single correct

• ANames of all the employees with at least one of their customers having a 'GOOD' rating.
• BNames of all the employees with at most one of their customers having a 'GOOD' rating.
• CNames of all the employees with none of their customers having a 'GOOD' rating.
• DNames of all the employees with all their customers having a 'GOOD' rating.