Passenger distribution on a route, range intersection

Hi all,   I have a table with train tickets like this:   ticketId departureName departureDistance arrivalName arrivalDistance 556822 Paris 0 Rome 1400 558874 Paris 0 Lion 700...