Show the short names of the buildings managed by "Emma".
CREATE TABLE Apartment_Buildings (building_short_name VARCHAR, building_manager VARCHAR)
[SQL] SELECT building_short_name FROM Apartment_Buildings WHERE building_manager = "Emma" [/SQL]