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

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'