CREATE TABLE table_name_31 (event VARCHAR2, total VARCHAR2)

What event did the shooter, who had 29 total points, compete in?
SELECT event FROM table_name_31 WHERE total = "29"
SELECT "event" FROM "table_name_31" WHERE "29" = "total"