CREATE TABLE table_name_54 (car NUMBER, player VARCHAR2)

How many carries for jeff smoker?
SELECT SUM(car) FROM table_name_54 WHERE player = "jeff smoker"
SELECT SUM("car") FROM "table_name_54" WHERE "jeff smoker" = "player"