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
apartment type code refers to apt_type_code; number of apartments having that apartment type refers to COUNT(*); in ascending order of the number of apartments refers to ORDER BY COUNT(*) ASC;