SELECT Status ,  COUNT(*) FROM roller_coaster GROUP BY Status
Show the different statuses and the numbers of roller coasters for each status.
SELECT Status , COUNT ( * ) FROM roller_coaster GROUP BY Status
select status , count ( * ) from roller_coaster group by status
Show the different statuses and the numbers of roller coasters for each status .