user: ### NOW ANSWER:
Question: Which County has a Rank larger than 8, and a Player of Joe McKenna?
Columns: ['Rank', 'Player', 'County', 'Tally', 'Total', 'Opposition']
Types: ['real', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'Éamonn Moroney', 'Clare', '2–4', 10.0, 'Waterford']
SQL:

assistant: SELECT "County" FROM "Table" WHERE "Rank" > 8.0 AND "Player" = 'Joe McKenna';