Table: hurling_stats
Columns: rank
player
county
tally
total
opposition

Question: What is the highest ranked player who opposed Westmeath?
SQL: SELECT MAX("rank") FROM hurling_stats WHERE "opposition" = 'westmeath'

Question: What is Tony O'Sullivan's county?
SQL: SELECT "county" FROM hurling_stats WHERE "player" = 'tony o''sullivan'