Table: hurling_stats
Columns: rank
player
county
tally
total
opposition

Question: Which County has a Rank larger than 8, and a Player of joe mckenna?
SQL: SELECT "county" FROM hurling_stats WHERE "rank" > 8 AND "player" = 'joe mckenna'

Question: Which Total has a County of kilkenny, and a Tally of 1–4, and a Rank larger than 10?
SQL: SELECT AVG("total") FROM hurling_stats WHERE "county" = 'kilkenny' AND "tally" = '1–4' AND "rank" > 10

Question: What is galway county's total?
SQL: SELECT SUM("total") FROM hurling_stats WHERE "county" = 'galway'