Table: lancashire_ccc_records_2
Columns: opposition
score
venue
city
year

Question: Which Opposition has a Year smaller than 1911, and a Venue of old trafford?
SQL: SELECT "opposition" FROM lancashire_ccc_records_2 WHERE "year" < 1911 AND "venue" = 'old trafford'

Question: Which Venue has a Year of 1911?
SQL: SELECT "venue" FROM lancashire_ccc_records_2 WHERE "year" = 1911

Question: Which Opposition has a City of taunton?
SQL: SELECT "opposition" FROM lancashire_ccc_records_2 WHERE "city" = 'taunton'

Question: Which number of Years has a Venue of old trafford, and an Opposition of yorkshire?
SQL: SELECT COUNT("year") FROM lancashire_ccc_records_2 WHERE "venue" = 'old trafford' AND "opposition" = 'yorkshire'