SELECT TOP 10
    Stations.StationID,
    SUM (CASE WHEN (FromStation = Stations.StationID) THEN 1 ELSE 0 END) AS NumTripsFrom,
    SUM (CASE WHEN ToStation = Stations.StationID  then 1 ELSE 0 END) AS NumTripsTo

FROM Trips, Stations
GROUP BY Stations.StationID
ORDER BY (SUM (CASE WHEN ToStation = Stations.StationID  then 1 ELSE 0 END) + SUM (CASE WHEN (FromStation = Stations.StationID) THEN 1 ELSE 0 END)) DESC, Stations.StationID ASC