CREATE TABLE station (network_name VARCHAR2, services VARCHAR2, id VARCHAR2)
CREATE TABLE route (station_id VARCHAR2)

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" "t1" JOIN "route" "t2" ON "t1"."id" = "t2"."station_id" GROUP BY "t2"."station_id"