CREATE TABLE Apartment_Buildings (building_short_name VARCHAR, building_manager VARCHAR)

Show the short names of the buildings managed by 'Emma'.
SELECT building_short_name FROM Apartment_Buildings WHERE building_manager = "Emma"
SELECT "building_short_name" FROM "Apartment_Buildings" WHERE "Emma" = "building_manager"