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

Find the number of trains for each station, as well as the station network name and services.
SELECT COUNT(*), t1.network_name, t1.services FROM station AS t1 JOIN route AS t2 ON t1.id = t2.station_id GROUP BY t2.station_id
SELECT COUNT(*), "t1"."network_name", "t1"."services" FROM "station" AS "t1" JOIN "route" AS "t2" ON "t1"."id" = "t2"."station_id" GROUP BY "t2"."station_id"