CREATE TABLE table_name_74 (score VARCHAR, venue VARCHAR, date VARCHAR)

What is the score at valley parade on 10/6/01?
SELECT score FROM table_name_74 WHERE venue = "valley parade" AND date = "10/6/01"
SELECT "score" FROM "table_name_74" WHERE "10/6/01" = "date" AND "valley parade" = "venue"