Table: hurling_stats_1964
Columns: rank
player
county
tally
total
opposition

Question: Which Rank has a Total of 12?
SQL: SELECT AVG("rank") FROM hurling_stats_1964 WHERE "total" = 12

Question: Which Rank has an Opposition of limerick?
SQL: SELECT "rank" FROM hurling_stats_1964 WHERE "opposition" = 'limerick'

Question: How much Rank has a Tally of 0-10, and an Opposition of cork?
SQL: SELECT COUNT("rank") FROM hurling_stats_1964 WHERE "tally" = '0-10' AND "opposition" = 'cork'

Question: Which Total has a Rank smaller than 3, and a County of cork?
SQL: SELECT MIN("total") FROM hurling_stats_1964 WHERE "rank" < 3 AND "county" = 'cork'

Question: Which Rank has a Tally of 4-0?
SQL: SELECT AVG("rank") FROM hurling_stats_1964 WHERE "tally" = '4-0'