How many stations does this train run through?
SELECT count ( * )  FROM train AS t1 JOIN route AS t2 ON t1.id   =   t2.train_id GROUP BY t2.train_id ORDER BY count ( * )  DESC LIMIT 1
number of stations a train runs through refers to COUNT(*) of the route entries for that train;