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

Visualize a bar chart for the number of trains for each station by the station network name, rank in asc by the X.
SELECT network_name, COUNT(*) FROM station AS t1 JOIN route AS t2 ON t1.id = t2.station_id GROUP BY t2.station_id ORDER BY network_name
SELECT "network_name", COUNT(*) FROM "station" AS "t1" JOIN "route" AS "t2" ON "t1"."id" = "t2"."station_id" GROUP BY "t2"."station_id" ORDER BY "network_name" NULLS FIRST