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

Question: List the fullName of every customer who never rented any car which has a rate $<=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 R$.$Rate $>10$;

None of the provided answers