Table: vik_churches
Columns: parish_prestegjeld
sub_parish_sokn
church_name
year_built
location_of_the_church

Question: Which parish has a church named Vangsnes Kyrkje?
SQL: SELECT "parish_prestegjeld" FROM vik_churches WHERE "church_name" = 'vangsnes kyrkje'

Question: Which Sub-Parish has a church built in 1866?
SQL: SELECT "sub_parish_sokn" FROM vik_churches WHERE "year_built" = '1866'

Question: When was the Hopperstad Stavkyrkje built?
SQL: SELECT "year_built" FROM vik_churches WHERE "church_name" = 'hopperstad stavkyrkje'

Question: When was the church in Arnafjord built?
SQL: SELECT "year_built" FROM vik_churches WHERE "location_of_the_church" = 'arnafjord'

Question: What is the Sub-Parish called that has a church located in Fresvik?
SQL: SELECT "sub_parish_sokn" FROM vik_churches WHERE "location_of_the_church" = 'fresvik'

Question: What is the church in the Sub-Parish of Fresvik called?
SQL: SELECT "church_name" FROM vik_churches WHERE "sub_parish_sokn" = 'fresvik'