CREATE TABLE table_name_42 (gold VARCHAR2, total NUMBER)

How many gold medals correspond with a total over 4?
SELECT gold FROM table_name_42 WHERE total > 4
SELECT "gold" FROM "table_name_42" WHERE "total" > 4