How many trains are there per station?
select t2.station_id, count ( * ) from station as t1 join route as t2 on t1.id = t2.station_id group by t2.station_id
What are the station network names?
select network_name from station
What services do they offer?
select services from station