CREATE TABLE table_68442 ("Rank" FLOAT, "Player" CLOB, "County" CLOB, "Tally" CLOB, "Total" FLOAT, "Matches" FLOAT, "Average" FLOAT)

What is the average total in the county of tipperary with a rank less than 1?
SELECT COUNT("Average") FROM table_68442 WHERE "County" = 'tipperary' AND "Rank" < '1'
SELECT COUNT("Average") FROM "table_68442" WHERE "County" = 'tipperary' AND "Rank" < '1'