Schema: CREATE TABLE roller_coaster (Status VARCHAR)
Question: Show the different statuses and the numbers of roller coasters for each status.
SQL: SELECT Status, COUNT(*) FROM roller_coaster GROUP BY Status