Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Please what is the answer to this question?23. SELECT MAKE FROM RENTALS, CUSTOMER

/in /by

Please what is the answer to this question?
23. 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 meaning of this query is the following:
A. List all makes of cars rented to customers residing in Hemet
B. List all makes of cars rented to at least one customer residing in Hemet
C. List all makes of cars rented to all customers residing in Hemet
D. None of the above

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"