Which buildings are in a studio?
select building_full_name from apartment_buildings where building_description = 'Studio'
What are their managers?
select building_manager from apartment_buildings where building_description = 'Studio'
Which of the building full names have the word "court" in it?
select building_full_name from apartment_buildings where building_full_name like '%court%'