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