Which County has a Rank larger than 8, and a Player of joe mckenna?
CREATE TABLE table_name_29 (county VARCHAR, rank VARCHAR, player VARCHAR)
SELECT county FROM table_name_29 WHERE rank > 8 AND player = "joe mckenna"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_29 (county VARCHAR, rank VARCHAR, player VARCHAR) Question: Which County has a Rank larger than 8, and a Player of joe mckenna? [/INST] SELECT county FROM table_name_29 WHERE rank > 8 AND player = "joe mckenna" </s>