instruction: How many bookings does each booking status have? List the booking status code and the number of corresponding bookings, and rank by the Y from low to high.
response: SELECT booking_status_code, COUNT(*) FROM Apartment_Bookings GROUP BY booking_status_code ORDER BY COUNT(*)