List all the building full names.
select building_full_name from apartment_buildings
Show the ones if there is the full name with "The Eugene".
select building_full_name from apartment_buildings where building_full_name like "The Eugene"
What are the building full names which contain the word "court"?
select building_full_name from apartment_buildings where building_full_name like "%court%"