user: Question: what is the minimum norwegian americans (1980) where state is Rhode Island
Columns: ['State', 'Norwegian Americans (1980)', 'Percent (1980)', 'Norwegian Americans (1990)', 'Percent (1990)', 'Norwegian Americans (2000)', 'Percent (2000)', 'Norwegian Americans (2009)', 'Percent (2009)']
Types: ['text', 'real', 'text', 'real', 'text', 'real', 'text', 'real', 'text']
Sample row: ['United States', 3453839.0, '1.8%', 3869395.0, '1.5%', 4477725.0, '1.6%', 4642526.0, '1.5%']
SQL:

assistant: SELECT MIN("Norwegian Americans (1980)") FROM "Table" WHERE "State" = 'Rhode Island';