What date was the most recent complaint raised?
select date_complaint_raised from complaints order by date_complaint_raised desc limit 1
Correct. Has the complaint raised at 2007-10-14 21:50:43 been closed?
select date_complaint_closed from complaints where date_complaint_raised = '2007-10-14 21:50:43'
Correct. What is the customer id for the complaint raised at 2007-10-14 21:50:43?
select customer_id from complaints where date_complaint_raised = '2007-10-14 21:50:43'
What is the phone number for customer id 118?
select phone_number from customers where customer_id = 118