CREATE TABLE table_name_79 (score VARCHAR, date VARCHAR)

What was the score on 10 November 2006?
SELECT score FROM table_name_79 WHERE date = "10 november 2006"
SELECT "score" FROM "table_name_79" WHERE "10 november 2006" = "date"