CREATE TABLE table_name_40 (total NUMBER, gold VARCHAR2, silver VARCHAR2)

Who scored the lowest with 8 gold medals and less than 4 silver medals?
SELECT MIN(total) FROM table_name_40 WHERE gold = 8 AND silver < 4
SELECT MIN("total") FROM "table_name_40" WHERE "gold" = 8 AND "silver" < 4