CREATE TABLE Apartments (apt_type_code VARCHAR2)

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 FETCH FIRST 1 ROWS ONLY