CREATE TABLE storm (storm_id NUMBER, name CLOB, dates_active CLOB, max_speed NUMBER, damage_millions_usd NUMBER, number_deaths NUMBER)
CREATE TABLE region (region_id NUMBER, region_code CLOB, region_name CLOB)
CREATE TABLE affected_region (region_id NUMBER, storm_id NUMBER, number_city_affected NUMBER)

What is the storm name and max speed which affected the greatest number of regions?
SELECT T1.name, T1.max_speed FROM storm AS T1 JOIN affected_region AS T2 ON T1.storm_id = T2.storm_id GROUP BY T1.storm_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name", "T1"."max_speed" FROM "storm" "T1" JOIN "affected_region" "T2" ON "T1"."storm_id" = "T2"."storm_id" GROUP BY "T1"."storm_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY