Table: finnish_provinces
Columns: map_number
english_name
finnish_name
swedish_name
residence_city
dates_of_existence
notes

Question: How many residence cities have an English name of Province of Viborg and Nyslott?
SQL: SELECT COUNT("residence_city") FROM finnish_provinces WHERE "english_name" = 'Province of Viborg and Nyslott'

Question: What is the highest value for map number?
SQL: SELECT MAX("map_number") FROM finnish_provinces

Question: What is every Swedish name for residence city is Loviisa?
SQL: SELECT "swedish_name" FROM finnish_provinces WHERE "residence_city" = 'Loviisa'

Question: What is every Finnish name for the English name of Province of Viborg and Nyslott?
SQL: SELECT "finnish_name" FROM finnish_provinces WHERE "english_name" = 'Province of Viborg and Nyslott'