Table: hurling_stats_4
Columns: rank
player
county
tally
total
opposition

Question: Which Player has a Total of 9, and an Opposition of offaly?
SQL: SELECT "player" FROM hurling_stats_4 WHERE "total" = 9 AND "opposition" = 'offaly'

Question: Which County has an Opposition of offaly?
SQL: SELECT "county" FROM hurling_stats_4 WHERE "opposition" = 'offaly'

Question: Which Player has a Total smaller than 11, and a Tally of 0-9?
SQL: SELECT "player" FROM hurling_stats_4 WHERE "total" < 11 AND "tally" = '0-9'