What is the answer to this question?
What is the answer to this question?
SELECT MAKE
FROM RENTALS, CUSTOMER
WHERE RENTALS.CID = CUSTOMER.CID AND RESID_CITY = ‘HEMET’
GROUP BY MAKE
HAVING COUNT (DISTINCT RENTALS.CID) =
(SELECT COUNT(*) FROM CUSTOMER
WHERE RESID_CITY = ‘HEMET’)
The execution of this query produces the following number of rows:
A. 0
B. 1
C. 2
D. 3