SELECT apt_type_code ,  COUNT(*) FROM Apartments GROUP BY apt_type_code ORDER BY COUNT(*) ASC
Show the apartment type codes and the corresponding number of apartments sorted by the number of apartments in ascending order.
SELECT apt_type_code , COUNT ( * ) FROM Apartments GROUP BY apt_type_code ORDER BY COUNT ( * ) ASC
select apt_type_code , count ( * ) from apartments group by apt_type_code order by count ( * ) asc
Show the apartment type codes and the corresponding number of apartments sorted by the number of apartments in ascending order .