Pages • 0
Dbms Subqueries Essay Preview: Dbms Subqueries Report this essay Find Carriers who have not delivered to more than 1 city (5 pts)SELECT C.CARRIER_NAMEFROM CARRIER CWHERE EXISTS (SELECT s1.carrier_name,count (DISTINCT s1.DESTINATION_CITY) CNTFROM shipment s1WHERE S1.CARRIER_NAME = C.CARRIER_NAMEGROUP BY s1.carrier_nameHAVING CNT