SCHEMA:
CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR)
USER:
Show the booking status code and the corresponding number of bookings.

QUERY:
SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code