user: Question: What is the average for the 1990s with a total of 1, and 0 in the 1980s?
Columns: ['1900s', '1920s', '1930s', '1940s', '1950s', '1960s', '1970s', '1980s', '1990s', '2000s to date', 'Total to date']
Types: ['real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [0.0, 0.0, 0.0, 1.0, 0.0, 0.0, 1.0, 0.0, 1.0, 1.0, 4.0]
SQL:

assistant: SELECT AVG("1990s") FROM "Table" WHERE "Total to date" = 1.0 AND "1980s" < 0.0;