Search for question
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