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

Show storm name with at least two regions and 10 cities affected.
SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id = T2.storm_id GROUP BY T1.storm_id HAVING COUNT(*) >= 2 INTERSECT SELECT T1.name FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id = T2.storm_id GROUP BY T1.storm_id HAVING SUM(T2.number_city_affected) >= 10
SELECT "T1"."name" FROM "storm" AS "T1" JOIN "affected_region" AS "T2" ON "T1"."storm_id" = "T2"."storm_id" GROUP BY "T1"."storm_id" HAVING COUNT(*) >= 2 INTERSECT SELECT "T1"."name" FROM "storm" AS "T1" JOIN "affected_region" AS "T2" ON "T1"."storm_id" = "T2"."storm_id" GROUP BY "T1"."storm_id" HAVING SUM("T2"."number_city_affected") >= 10