CREATE TABLE table_34942 ("Date" CLOB, "Opponent#" CLOB, "Site" CLOB, "Result" CLOB, "Attendance" CLOB)

What is the Attendance number when the Opponent was purdue?
SELECT "Attendance" FROM table_34942 WHERE "Opponent#" = 'purdue'
SELECT "Attendance" FROM "table_34942" WHERE "Opponent#" = 'purdue'