By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
id | origin | destination | cost |
---|---|---|---|
1 | SFO | JFK | 500 |
2 | SFO | DFW | 200 |
3 | SFO | MCO | 400 |
4 | DFW | MCO | 100 |
5 | DFW | JFK | 200 |
6 | JFK | LHR | 1000 |
origin | destination | cost | path | stops_count |
---|---|---|---|---|
DFW | JFK | 200 | 5 | 0 |
DFW | LHR | 1200 | 5,6 | 1 |
DFW | MCO | 100 | 4 | 0 |
JFK | LHR | 1000 | 6 | 0 |
SFO | DFW | 200 | 2 | 0 |
SFO | JFK | 400 | 2,5 | 1 |
SFO | LHR | 1400 | 2,5,6 | 2 |
SFO | MCO | 300 | 2,4 | 1 |
origin | destination | cost | path | stops_count |
---|---|---|---|---|
DFW | JFK | 200 | 5 | 0 |
DFW | LHR | 1200 | 5,6 | 1 |
DFW | MCO | 100 | 4 | 0 |
JFK | LHR | 1000 | 6 | 0 |
SFO | DFW | 200 | 2 | 0 |
SFO | JFK | 400 | 2,5 | 1 |
SFO | LHR | 1400 | 2,5,6 | 2 |
SFO | MCO | 300 | 2,4 | 1 |