List all the guests' first and last names.
select guest_first_name, guest_last_name from guests
Among all the guests, which of them have "Provisional" the apartment bookings?
select t2.guest_first_name, 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"
How about "Confirmed"?
select t2.guest_first_name, 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"