CREATE TABLE table_47859 ("Date" CLOB, "Time" CLOB, "Opponent" CLOB, "Site" CLOB, "City" CLOB)

What team was the opponent on 03/18/08?
SELECT "Opponent" FROM table_47859 WHERE "Date" = '03/18/08'
SELECT "Opponent" FROM "table_47859" WHERE "Date" = '03/18/08'