CREATE TABLE table_79462 ("Rank" FLOAT, "Player" CLOB, "County" CLOB, "Tally" CLOB, "Total" FLOAT, "Opposition" CLOB)

Which County has a Rank larger than 8, and a Player of joe mckenna?
SELECT "County" FROM table_79462 WHERE "Rank" > '8' AND "Player" = 'joe mckenna'
SELECT "County" FROM "table_79462" WHERE "Player" = 'joe mckenna' AND "Rank" > '8'