CREATE TABLE table_name_8 (location VARCHAR2, opponent VARCHAR2)

Where did they play against Clemson?
SELECT location FROM table_name_8 WHERE opponent = "clemson"
SELECT "location" FROM "table_name_8" WHERE "clemson" = "opponent"