SELECT apt_type_code ,  COUNT(*) FROM Apartments GROUP BY apt_type_code ORDER BY COUNT(*) ASC
Return each apartment type code with the number of apartments having that apartment type, in ascending order of the number of apartments.
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
Return each apartment type code with the number of apartments having that apartment type , in ascending order of the number of apartments .