* I have left the chat *
select 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 name and services for  these station
select t1.network_name, t1.services from station as t1 join route as t2 on t1.id = t2.station_id group by t2.station_id
include station id in the list
select t1.network_name, t1.services,station_id from station as t1 join route as t2 on t1.id = t2.station_id group by t2.station_id