CREATE TABLE table_name_40 (total INT, gold VARCHAR, silver VARCHAR)

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