Which apartment type code appears the most often?
SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY count(*) DESC LIMIT 1
apartment type code appears the most often refers to MAX(COUNT(apt_type_code));