CREATE TABLE affected_region (storm_id VARCHAR)
CREATE TABLE storm (name VARCHAR, storm_id VARCHAR)

List the name for storms and the number of affected regions for each storm.
SELECT T1.name, COUNT(*) FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id = T2.storm_id GROUP BY T1.storm_id
SELECT "T1"."name", COUNT(*) FROM "storm" AS "T1" JOIN "affected_region" AS "T2" ON "T1"."storm_id" = "T2"."storm_id" GROUP BY "T1"."storm_id"