What is the booking status of the apartment with number "Suite 634"?
SELECT T1.booking_status_code FROM Apartment_Bookings AS T1 JOIN Apartments AS T2 ON T1.apt_id   =   T2.apt_id WHERE T2.apt_number   =   "Suite 634"
booking status of the apartment refers to booking_status_code; apartment with number 'Suite 634' refers to WHERE clause filtering by apt_number = 'Suite 634'; joining Apartment_Bookings and Apartments tables to correlate booking status with a specific apartment number;