Show the short names of the buildings managed by "Emma".
CREATE TABLE Apartment_Buildings (building_short_name VARCHAR, building_manager VARCHAR)
SELECT building_short_name FROM Apartment_Buildings WHERE building_manager = "Emma"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Apartment_Buildings (building_short_name VARCHAR, building_manager VARCHAR) Question: Show the short names of the buildings managed by "Emma". [/INST] SELECT building_short_name FROM Apartment_Buildings WHERE building_manager = "Emma" </s>