What are the building full names that contain the word "court"?
CREATE TABLE Apartment_Buildings (building_full_name VARCHAR)
[SQL] SELECT building_full_name FROM Apartment_Buildings WHERE building_full_name LIKE "%court%" [/SQL]