Please show me all the information about each apartment
select * from apartments
Now just the info for Suite 634
select * from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.apt_number = "Suite 634"
and now just show the booking status code for that suite
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"