CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR)

Show the booking status code and the corresponding number of bookings.
SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code
SELECT "booking_status_code", COUNT(*) FROM "Apartment_Bookings" GROUP BY "booking_status_code"