CREATE TABLE table_name_96 (gold NUMBER, total VARCHAR2, rank VARCHAR2, silver VARCHAR2)

What is the most gold medals that a team ranked higher than 6, have 1 silver medal, and more than 4 total medals have?
SELECT MAX(gold) FROM table_name_96 WHERE rank < 6 AND silver = 1 AND total > 4
SELECT MAX("gold") FROM "table_name_96" WHERE "rank" < 6 AND "silver" = 1 AND "total" > 4