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 for the following question.

Question: List the fullName of every customer who only rented cars which have rates $<10$ dollar.

Group of answer choices

SELECT R$.$FullNAME

FROM RentalTransaction R

WHERE FullName NOT IN$($ SELECT RR$.$FullName

FROM RentalTransaction RR $,$ CARS C

WHERE RR$.$PLateNumber $=$ C$.$PlateNumber AND C$.$Rate $>=10)$;

SELECT R$.$FullNAME

FROM RentalTransaction R

WHERE FullName NOT IN $\{$ SELECT RR$.$FullName

FROM RentalTransaction RR $,$ CARS C

WHERE RR$.$PLateNumber $=$ C$.$PlateNumber AND C$.$Rate $<10\}$;

SELECT R$.$FullNAME

FROM RentalTransaction R

WHERE FullName IN$($ SELECT RR$.$FullName

FROM RentalTransaction RR $,$ CARS C

WHERE RR$.$PLateNumber $=$ C$.$PlateNumber AND C$.$Rate $<0)$;

None of the provided answers