CREATE TABLE table_name_45 (total INT, player VARCHAR, tally VARCHAR)

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