human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, Player, County, Tally, Total, Opposition
###Question: Which County has a Rank larger than 8, and a Player of joe mckenna?
gpt
SELECT County FROM table WHERE Rank > 8 AND Player = joe mckenna