
CREATE TABLE affected_region (
	"Region_id" INTEGER, 
	"Storm_ID" INTEGER, 
	"Number_city_affected" REAL, 
	PRIMARY KEY ("Region_id", "Storm_ID"), 
	FOREIGN KEY("Storm_ID") REFERENCES storm ("Storm_ID"), 
	FOREIGN KEY("Region_id") REFERENCES region ("Region_id")
)


CREATE TABLE region (
	"Region_id" INTEGER, 
	"Region_code" TEXT, 
	"Region_name" TEXT, 
	PRIMARY KEY ("Region_id")
)


CREATE TABLE storm (
	"Storm_ID" INTEGER, 
	"Name" TEXT, 
	"Dates_active" TEXT, 
	"Max_speed" INTEGER, 
	"Damage_millions_USD" REAL, 
	"Number_Deaths" INTEGER, 
	PRIMARY KEY ("Storm_ID")
)

CREATE TABLE affected_region (
	"Region_id" INTEGER, 
	"Storm_ID" INTEGER, 
	"Number_city_affected" REAL, 
	PRIMARY KEY ("Region_id", "Storm_ID"), 
	FOREIGN KEY("Storm_ID") REFERENCES storm ("Storm_ID"), 
	FOREIGN KEY("Region_id") REFERENCES region ("Region_id")
)

/*
2 rows from affected_region table:
Region_id	Storm_ID	Number_city_affected
1	1	10.0
2	1	15.0
*/


CREATE TABLE region (
	"Region_id" INTEGER, 
	"Region_code" TEXT, 
	"Region_name" TEXT, 
	PRIMARY KEY ("Region_id")
)

/*
2 rows from region table:
Region_id	Region_code	Region_name
1	AF	Afghanistan
2	AL	Albania
*/


CREATE TABLE storm (
	"Storm_ID" INTEGER, 
	"Name" TEXT, 
	"Dates_active" TEXT, 
	"Max_speed" INTEGER, 
	"Damage_millions_USD" REAL, 
	"Number_Deaths" INTEGER, 
	PRIMARY KEY ("Storm_ID")
)

/*
2 rows from storm table:
Storm_ID	Name	Dates_active	Max_speed	Damage_millions_USD	Number_Deaths
1	One	May19–May25	995	13.0	0
2	Two	August3–August10	972	10.75	7
*/
What are the names of storms that did not affect any regions?
SELECT name FROM storm WHERE storm_id NOT IN (SELECT storm_id FROM affected_region)
[{'Name': 'Two'}, {'Name': 'Six'}, {'Name': 'Seven'}, {'Name': 'Eight'}, {'Name': 'Nine'}, {'Name': '9 cyclones'}]