CREATE TABLE table_7586 ("1900s" FLOAT, "1920s" FLOAT, "1930s" FLOAT, "1940s" FLOAT, "1950s" FLOAT, "1960s" FLOAT, "1970s" FLOAT, "1980s" FLOAT, "1990s" FLOAT, "2000s to date" FLOAT, "Total to date" FLOAT)

What was the lowest in the 1930s, has more than 1 in the 1940s, 0 in the 1990s, and a total to date of less than 17?
SELECT MIN("1930s") FROM table_7586 WHERE "1940s" > '1' AND "1990s" < '1' AND "Total to date" < '17'
SELECT MIN("1930s") FROM "table_7586" WHERE "1940s" > '1' AND "1990s" < '1' AND "Total to date" < '17'