Show the booking status code and the corresponding number of bookings.
CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR)
SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Apartment_Bookings (booking_status_code VARCHAR) Question: Show the booking status code and the corresponding number of bookings. [/INST] SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code </s>