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

Which Total has a County of kilkenny, and a Tally of 1 4, and a Rank larger than 10?
SELECT AVG("Total") FROM table_79463 WHERE "County" = 'kilkenny' AND "Tally" = '1–4' AND "Rank" > '10'
SELECT AVG("Total") FROM "table_79463" WHERE "County" = 'kilkenny' AND "Rank" > '10' AND "Tally" = '1–4'