CREATE TABLE guests (guest_id DECIMAL, gender_code TEXT, guest_first_name TEXT, guest_last_name TEXT, date_of_birth TIME)
CREATE TABLE apartments (apt_id DECIMAL, building_id DECIMAL, apt_type_code TEXT, apt_number TEXT, bathroom_count DECIMAL, bedroom_count DECIMAL, room_count TEXT)
CREATE TABLE apartment_bookings (apt_booking_id DECIMAL, apt_id DECIMAL, guest_id DECIMAL, booking_status_code TEXT, booking_start_date TIME, booking_end_date TIME)
CREATE TABLE apartment_facilities (apt_id DECIMAL, facility_code TEXT)
CREATE TABLE view_unit_status (apt_id DECIMAL, apt_booking_id DECIMAL, status_date TIME, available_yn others)
CREATE TABLE apartment_buildings (building_id DECIMAL, building_short_name TEXT, building_full_name TEXT, building_description TEXT, building_address TEXT, building_manager TEXT, building_phone TEXT)

Show the first names and last names of all the guests that have apartment bookings with status code '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"
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 "Confirmed" = "T1"."booking_status_code"