List all the guests' first and last names.
select guest_first_name, guest_last_name from guests
Also show the booking status code of each one.
select t2.guest_first_name, t2.guest_last_name, t1.booking_status_code from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id
What are the first names, start dates, and end dates of all the apartment bookings?
select t2.guest_first_name, t1.booking_start_date, t1.booking_start_date from apartment_bookings as t1 join guests as t2 on t1.guest_id = t2.guest_id