How can I group Trips that have the same SOURCE_LOCATION or DESTINATION_LOCATION? Trips table, where LOCATIONS column contains list of locations:
SOURCE_LOCATION
DESTINATION_LOCATION
LOCATIONS
should help.