List all the unique booking status codes.
select distinct booking_status_code from apartment_bookings
How many apartments are there for each one?
select booking_status_code, count(*) from apartment_bookings group by booking_status_code