CREATE TABLE table_name_13 (total NUMBER, rank VARCHAR2, county VARCHAR2, tally VARCHAR2)

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