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
number of trains for each station refers to COUNT(*); station network name refers to t1.network_name; services refers to t1.services; joining of two tables station and route on a common column refers to JOIN operation on t1.id = t2.station_id; grouping results by station_id refers to GROUP BY t2.station_id;