Table: lancashire_cc_records_4
Columns: score
opposition
venue
city
year

Question: What score has Leicestershire as the opponent after 1906?
SQL: SELECT "score" FROM lancashire_cc_records_4 WHERE "opposition" = 'leicestershire' AND "year" > 1906

Question: Where in Buxton has 3 runs?
SQL: SELECT "venue" FROM lancashire_cc_records_4 WHERE "score" = '3 runs' AND "city" = 'buxton'

Question: What city was in 1889?
SQL: SELECT "city" FROM lancashire_cc_records_4 WHERE "year" = 1889

Question: What is the score in Leicester?
SQL: SELECT "score" FROM lancashire_cc_records_4 WHERE "city" = 'leicester'

Question: How many years has 1 run?
SQL: SELECT COUNT("year") FROM lancashire_cc_records_4 WHERE "score" = '1 run'

Question: What year was in Aigburth?
SQL: SELECT MAX("year") FROM lancashire_cc_records_4 WHERE "venue" = 'aigburth'