Show the name for regions not affected.
CREATE TABLE region (region_name VARCHAR, region_id VARCHAR); CREATE TABLE affected_region (region_name VARCHAR, region_id VARCHAR)
SELECT region_name FROM region WHERE NOT region_id IN (SELECT region_id FROM affected_region)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE region (region_name VARCHAR, region_id VARCHAR); CREATE TABLE affected_region (region_name VARCHAR, region_id VARCHAR) Question: Show the name for regions not affected. [/INST] SELECT region_name FROM region WHERE NOT region_id IN (SELECT region_id FROM affected_region) </s>