What are the building short name of building id 133?
select building_short_name from apartment_buildings where building_id = 133
Who is building manager of Mercedes House?
select building_manager from apartment_buildings where building_full_name = "Mercedes House"
Find the building address of building manager Melyssa.
select building_address from apartment_buildings where building_manager = "Melyssa"
What are the building full names that contain the word "court"?
select building_full_name from apartment_buildings where building_full_name like "%court%"