Show the name of storms which don't have affected region in record.
CREATE TABLE affected_region (name VARCHAR, storm_id VARCHAR); CREATE TABLE storm (name VARCHAR, storm_id VARCHAR)
SELECT name FROM storm WHERE NOT storm_id IN (SELECT storm_id FROM affected_region)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE affected_region (name VARCHAR, storm_id VARCHAR); CREATE TABLE storm (name VARCHAR, storm_id VARCHAR) Question: Show the name of storms which don't have affected region in record. [/INST] SELECT name FROM storm WHERE NOT storm_id IN (SELECT storm_id FROM affected_region) </s>