CREATE TABLE Apartments (apt_number VARCHAR, apt_type_code VARCHAR)

Return the apartment numbers of the apartments with type code 'Flat'.
SELECT apt_number FROM Apartments WHERE apt_type_code = "Flat"
SELECT "apt_number" FROM "Apartments" WHERE "Flat" = "apt_type_code"