Table: hurling_1992
Columns: rank
player
county
tally
total
opposition

Question: What is the tally with a total larger than 8, Waterford was the opposition?
SQL: SELECT "tally" FROM hurling_1992 WHERE "total" > 8 AND "opposition" = 'waterford'

Question: What is the tally when the opposition is Derry, and total is 14?
SQL: SELECT "tally" FROM hurling_1992 WHERE "opposition" = 'derry' AND "total" = 14