Given the following database schema for a rental car business. Use SQL to express each of the following queries using a minimum number of operations and tables:

Cars$($ PlateNumber, Make, Rate, Status$)//$ Status $=$ available or null $($rented out$)$; Rate $=$ the daily charge in dollars.

Customer $($ FullName, PhoneNumber, DLNumber, CreditCardNumber$)$

RentalTranscation $($ TranscationNumber, FullName, PlateNumber, PickUpDate, ReturnDate$)//$ ReturnDate may assume the value null if it hasn$$t been returned and you may treat the dates as integers

Select the correct SQL query that answers the following question.

Question: List the full name who rented out every car $($all cars$)$ which have rate $<=10$ dollar.

Group of answer choices

SELECT C$.$FullName

FROM Customer C

WHERE NOT EXIST $($ SELECT CA$.$ PlateNumber

FROM Cars CA

WHERE CA$.$Rate $<=10$ AND CA$.$ PlateNumber NOT IN

$($ SELECT RR$.$ PlateNumber FROM RentalTransaction RR

WHERE RR$.$FullName$=$ C$.$FullName$)$

$)$;

SELECT C$.$FullName

FROM Customer C

WHERE EXIST $($ SELECT CA$.$PlateNumber

FROM Cars CA

WHERE CA$.$ Rate $<=10$ AND CA$.$PlateNumber NOT IN $($

SELECT RR$.$ PlateNumber

FROM RentalTransaction RR

WHERE RR$.$ FullName$=$ C$.$FullName$)$

$)$;

SELECT C$.$FullName

FROM Customer C

WHERE NOT EXIST $($ SELECT CA$.$ PlateNumber

FROM CARS CA

WHERE CA$.$Rate $<=10$ AND CA$.$ PlateNumber NOT IN

$($ SELECT RR$.$ PlateNumber

FROM RentalTransaction RR$)$

$)$;

None of the provided answers