Table: church_info
Columns: parish_prestegjeld
sub_parish_sokn
church_name
year_built
location_of_the_church

Question: What's the name of the church in Stavang?
SQL: SELECT "church_name" FROM church_info WHERE "location_of_the_church" = 'Stavang'

Question: What's the name of the church in Stavang?
SQL: SELECT "church_name" FROM church_info WHERE "location_of_the_church" = 'Stavang'

Question: What's the sub-parish (sokn) of Eikefjord?
SQL: SELECT "sub_parish_sokn" FROM church_info WHERE "location_of_the_church" = 'Eikefjord'

Question: On how many locations is there a church named Askrova Bedehuskapell, built in 1957?
SQL: SELECT COUNT("location_of_the_church") FROM church_info WHERE "year_built" = '1957' AND "church_name" = 'Askrova bedehuskapell'

Question: In what parish is the Askrova Bedehuskapell church?
SQL: SELECT "parish_prestegjeld" FROM church_info WHERE "church_name" = 'Askrova bedehuskapell'