Table: hurling_stats_10
Columns: rank
player
county
tally
total
opposition

Question: What is the average total of the 0-8 tally?
SQL: SELECT AVG("total") FROM hurling_stats_10 WHERE "tally" = '0-8'

Question: What is the total rank of the match with tipperary as the opposition?
SQL: SELECT COUNT("rank") FROM hurling_stats_10 WHERE "opposition" = 'tipperary'

Question: What is the lowest total of player tommy ring, who has a rank greater than 1?
SQL: SELECT MIN("total") FROM hurling_stats_10 WHERE "player" = 'tommy ring' AND "rank" > 1

Question: What is the average rank of the match where offaly was the opposition and the total was greater than 9?
SQL: SELECT AVG("rank") FROM hurling_stats_10 WHERE "opposition" = 'offaly' AND "total" > 9