CREATE TABLE table_name_10 (year_joined NUMBER, location VARCHAR2)

When did crawfordsville join?
SELECT MAX(year_joined) FROM table_name_10 WHERE location = "crawfordsville"
SELECT MAX("year_joined") FROM "table_name_10" WHERE "crawfordsville" = "location"