Database: station_weather
Question: Find the number of trains for each station, as well as the station network name and services.
SQL:
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