Which buildings does "Emma" manage? Give me the short names of the buildings.
SELECT building_short_name FROM Apartment_Buildings WHERE building_manager	 =  "Emma"
buildings managed by 'Emma' refers to building_manager = 'Emma'; short names of the buildings refers to building_short_name;