Question

Query 4 When a car is returned by the member, the system will need to check the queue to see if there are any people on the waitlist. Write the query to produce the list of people on the waitlist and order the output by the date_created attribute. The output should contain the following columns to allow the manager to phone the customers to let them know their requested car is available. first_name last_name phone Rene Karyl date_created Hallford 637-100-6827 2023-08-05 09:30:00 Gomme 446-710-2128 2023-09-01 08:30:00

Fig: 1