What are the first names of all guest with apartment booking status "Confirmed" ?
select t2.guest_first_name from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t1.booking_status_code = "Confirmed"
And how about their last names?
select t2.guest_last_name from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t1.booking_status_code = "Confirmed"
And what about guests with "Provisional" status?
select t2.guest_last_name from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id where t1.booking_status_code = "Provisional"