CREATE TABLE table_54033 ("Rank" FLOAT, "Player" TEXT, "County" TEXT, "Tally" TEXT, "Total" FLOAT, "Opposition" TEXT)

What was the total for David O'Callaghan, and a Tally of 1-9?
SELECT SUM("Total") FROM table_54033 WHERE "Player" = 'david o''callaghan' AND "Tally" = '1-9'
SELECT SUM("Total") FROM "table_54033" WHERE "Player" = 'david o\'callaghan' AND "Tally" = '1-9'