Table: pwcamps
Columns: camp
place
province
location
period

Question: Tell me the period for red rock
SQL: SELECT "period" FROM pwcamps WHERE "place" = 'red rock'

Question: Tell me the province for 260km ese of calgary
SQL: SELECT "province" FROM pwcamps WHERE "location" = '260km ese of calgary'

Question: Tell me the province of 1941-1946
SQL: SELECT "province" FROM pwcamps WHERE "period" = '1941-1946'