What is the booking status code of the apartment with apartment number "Suite 634"?
create table apartments (apt_id varchar, apt_number varchar, PRIMARY KEY (apt_id)); create table apartment_bookings (booking_status_code varchar, apt_id varchar, PRIMARY KEY (booking_status_code))
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"