List all the unique booking status codes.
select distinct booking_status_code from apartment_bookings
How many are there?
select count(distinct booking_status_code) from apartment_bookings
Show these codes with apartment numbers.
select t1.booking_status_code, t2.apt_number from apartment_bookings as t1 join apartments as t2 on t1.apt_id = t2.apt_id
What is the code of the apartment with apartment 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"