Table: us_norwegian_americans
Columns: state
norwegian_americans_1980
percent_1980
norwegian_americans_1990
percent_1990
norwegian_americans_2000
percent_2000
norwegian_americans_2009
percent_2009

Question: what are all the percent (1990) where state is united states
SQL: SELECT "percent_1990" FROM us_norwegian_americans WHERE "state" = 'United States'

Question: what is the total number of percent (2000) where percent (1980) is 3.4%
SQL: SELECT COUNT("percent_2000") FROM us_norwegian_americans WHERE "percent_1980" = '3.4%'

Question: what are all the percent (1990) where state is mississippi
SQL: SELECT "percent_1990" FROM us_norwegian_americans WHERE "state" = 'Mississippi'

Question: what is the maximum norwegian americans (2000) where norwegian americans (1990) is 9170
SQL: SELECT MAX("norwegian_americans_2000") FROM us_norwegian_americans WHERE "norwegian_americans_1990" = 9170

Question: what is the minimum norwegian americans (1980) where state is rhode island
SQL: SELECT MIN("norwegian_americans_1980") FROM us_norwegian_americans WHERE "state" = 'Rhode Island'