Qual é a menor patente quando há menos de 1 prata, 4 dourados e menos de 0 bronze?
CREATE TABLE table_name_10 (rank INTEGER, bronze VARCHAR, silver VARCHAR, gold VARCHAR)
SELECT MIN(rank) FROM table_name_10 WHERE silver < 1 AND gold = 4 AND bronze < 0