CREATE TABLE table_name_40 (total VARCHAR2, player VARCHAR2)

What was Mark O'Meara's total?
SELECT total FROM table_name_40 WHERE player = "mark o'meara"
SELECT "total" FROM "table_name_40" WHERE "mark o'meara" = "player"