Table: lancashire_cc_records
Columns: score
opposition
venue
city
year

Question: Which Opposition has a Year smaller than 1977, and a City of manchester?
SQL: SELECT "opposition" FROM lancashire_cc_records WHERE "year" < 1977 AND "city" = 'manchester'

Question: Which Score is the lowest one that has a Year of 1868?
SQL: SELECT MIN("score") FROM lancashire_cc_records WHERE "year" = 1868

Question: Which Venue has a Year larger than 1868, and an Opposition of derbyshire?
SQL: SELECT "venue" FROM lancashire_cc_records WHERE "year" > 1868 AND "opposition" = 'derbyshire'

Question: Which City has a Score smaller than 30, and a Venue of aigburth?
SQL: SELECT "city" FROM lancashire_cc_records WHERE "score" < 30 AND "venue" = 'aigburth'