How many bookings does each booking status have? List the booking status code and the number of corresponding bookings.
SELECT 	booking_status_code ,  COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code
number of bookings for each booking status refers to COUNT(*) GROUPED BY booking_status_code;