SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY count(*) DESC LIMIT 1
Show the most common apartment type code.
SELECT apt_type_code FROM Apartments GROUP BY apt_type_code ORDER BY count ( * ) DESC LIMIT 1
select apt_type_code from apartments group by apt_type_code order by count ( * ) desc limit value
Show the most common apartment type code .