Table: hurling_stats_2008
Columns: rank
player
county
tally
total
opposition

Question: What was the total for David O'Callaghan, and a Tally of 1-9?
SQL: SELECT SUM("total") FROM hurling_stats_2008 WHERE "player" = 'david o''callaghan' AND "tally" = '1-9'

Question: What is the opposition when the tally was 0-11?
SQL: SELECT "opposition" FROM hurling_stats_2008 WHERE "tally" = '0-11'

Question: What is the tally in Kilkenny county with 10 as the total and opposition of Waterford?
SQL: SELECT "tally" FROM hurling_stats_2008 WHERE "county" = 'kilkenny' AND "total" = 10 AND "opposition" = 'waterford'