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 | JFK | 500 | 1 | 0 |
| SFO | LHR | 1400 | 2,5,6 | 2 |
| SFO | LHR | 1500 | 1,6 | 1 |
| SFO | MCO | 300 | 2,4 | 1 |
| SFO | MCO | 400 | 3 | 0 |