CREATE TABLE table_name_9 (shooter VARCHAR2, total VARCHAR2)

What Shooter has a Total of 28?
SELECT shooter FROM table_name_9 WHERE total = "28"
SELECT "shooter" FROM "table_name_9" WHERE "28" = "total"