Table: hurling_stats
Columns: rank
player
county
tally
total
matches
average

Question: How many totals are there for players with an average under 8 and less than 4 matches?
SQL: SELECT COUNT("total") FROM hurling_stats WHERE "average" < 8 AND "matches" < 4

Question: What is the highest rank for championships with christy heffernan with over 4 matches?
SQL: SELECT MAX("rank") FROM hurling_stats WHERE "player" = 'christy heffernan' AND "matches" > 4