Table: hurling_stats_2
Columns: rank
player
county
tally
total
opposition

Question: Which Player has an Opposition of clare?
SQL: SELECT "player" FROM hurling_stats_2 WHERE "opposition" = 'clare'

Question: Which Total has a Player of matt ruth?
SQL: SELECT "total" FROM hurling_stats_2 WHERE "player" = 'matt ruth'

Question: Which Rank has a Player of matt ruth?
SQL: SELECT SUM("rank") FROM hurling_stats_2 WHERE "player" = 'matt ruth'