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