CREATE TABLE table_5767 ("Opposition" CLOB, "Score" CLOB, "Venue" CLOB, "City" CLOB, "Year" FLOAT)

Which number of Years has a Venue of old trafford, and an Opposition of yorkshire?
SELECT COUNT("Year") FROM table_5767 WHERE "Venue" = 'old trafford' AND "Opposition" = 'yorkshire'
SELECT COUNT("Year") FROM "table_5767" WHERE "Opposition" = 'yorkshire' AND "Venue" = 'old trafford'