Table: lancashire_cc_records
Columns: score
opposition
venue
city
year

Question: How many years had a score of 734-5d?
SQL: SELECT COUNT("year") FROM lancashire_cc_records WHERE "score" = '734-5d'

Question: Which venue had a city of Manchester before 2003?
SQL: SELECT "venue" FROM lancashire_cc_records WHERE "city" = 'manchester' AND "year" < 2003

Question: Which venue had a city of Manchester in 2003?
SQL: SELECT "venue" FROM lancashire_cc_records WHERE "city" = 'manchester' AND "year" = 2003

Question: Which venue had a score of 734-5d?
SQL: SELECT "venue" FROM lancashire_cc_records WHERE "score" = '734-5d'