CREATE TABLE station (id NUMBER, network_name CLOB, services CLOB, local_authority CLOB)
CREATE TABLE route (train_id NUMBER, station_id NUMBER)
CREATE TABLE train (id NUMBER, train_number NUMBER, name CLOB, origin CLOB, destination CLOB, time CLOB, interval CLOB)
CREATE TABLE weekly_weather (station_id NUMBER, day_of_week CLOB, high_temperature NUMBER, low_temperature NUMBER, precipitation NUMBER, wind_speed_mph NUMBER)

Find the name of the train whose route runs through greatest number of stations.
SELECT t1.name FROM train AS t1 JOIN route AS t2 ON t1.id = t2.train_id GROUP BY t2.train_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "t1"."name" FROM "train" "t1" JOIN "route" "t2" ON "t1"."id" = "t2"."train_id" GROUP BY "t2"."train_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY