Table: norway_counties_rank
Columns: rank
county
1960
2000
2040

Question: Which county has a % (2040) larger than 1.8, a % (2000) smaller than 4.1, a % (1960) smaller than 3.2, and is ranked 13?
SQL: SELECT "county" FROM norway_counties_rank WHERE "2040" > 1.8 AND "2000" < 4.1 AND "1960" < 3.2 AND "rank" = '13'

Question: What is the % (1960) of Troms, which has a % (2040) smaller than 100 and a % (2000) smaller than 4.7?
SQL: SELECT SUM("1960") FROM norway_counties_rank WHERE "2040" < 100 AND "2000" < 4.7 AND "county" = 'troms'

Question: What is the % (1960) of the county with a % (2040) of 3.4?
SQL: SELECT COUNT("1960") FROM norway_counties_rank WHERE "2040" = 3.4