By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
| rake_name | origin | destination | created_At | bpc_issue_date | departure_time | journey_distance | bpc_balance_distance_km | abc | rn | logic |
|---|---|---|---|---|---|---|---|---|---|---|
| ARIL-05 | a | b | 2024-02-09 06:37:00 | 2024-02-08 18:30:00 | 2024-02-09 13:40:00 | 173.46000670 | 5271 | 5098 | 1 | 5271-173.4600067 |
| ARIL-05 | a | b | 2024-02-11 02:58:00 | 2024-02-08 18:30:00 | 2024-02-11 04:15:00 | 1099.36999500 | 5271 | 3998 | 2 | 5097-1099 |
| ARIL-05 | a | b | 2024-02-14 12:46:00 | 2024-02-08 18:30:00 | 2024-02-14 15:50:00 | 1099.36999500 | 5271 | 2898 | 3 | 3998-1099 |
| ARIL-05 | a | b | 2024-02-16 17:29:00 | 2024-02-08 18:30:00 | 2024-02-17 02:30:00 | 175.66000370 | 5271 | 2713 | 4 | 2898-175 |
| ARIL-05 | a | b | 2024-02-17 10:54:00 | 2024-02-08 18:30:00 | 2024-02-18 11:30:00 | 1178.88000500 | 5271 | 1544 | 5 | 2713-1178 |
| ARIL-05 | a | b | 2024-02-20 11:44:00 | 2024-02-08 18:30:00 | 2024-02-20 15:20:00 | 1179.36999500 | 5271 | 364 | 6 | 1544-1179 |
| rake_name | origin | destination | created_At | bpc_issue_date | departure_time | journey_distance | bpc_balance_distance_km | abc | rn | logic | nabc | final_result |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ARIL-05 | a | b | 2024-02-09 06:37:00 | 2024-02-08 18:30:00 | 2024-02-09 13:40:00 | 173.46000670 | 5271 | 5098 | 1 | 5271-173.4600067 | 5097.53999330 | 5098 |
| ARIL-05 | a | b | 2024-02-11 02:58:00 | 2024-02-08 18:30:00 | 2024-02-11 04:15:00 | 1099.36999500 | 5271 | 3998 | 2 | 5097-1099 | 3998.16999830 | 3998 |
| ARIL-05 | a | b | 2024-02-14 12:46:00 | 2024-02-08 18:30:00 | 2024-02-14 15:50:00 | 1099.36999500 | 5271 | 2898 | 3 | 3998-1099 | 2898.80000330 | 2899 |
| ARIL-05 | a | b | 2024-02-16 17:29:00 | 2024-02-08 18:30:00 | 2024-02-17 02:30:00 | 175.66000370 | 5271 | 2713 | 4 | 2898-175 | 2723.13999960 | 2723 |
| ARIL-05 | a | b | 2024-02-17 10:54:00 | 2024-02-08 18:30:00 | 2024-02-18 11:30:00 | 1178.88000500 | 5271 | 1544 | 5 | 2713-1178 | 1544.25999460 | 1544 |
| ARIL-05 | a | b | 2024-02-20 11:44:00 | 2024-02-08 18:30:00 | 2024-02-20 15:20:00 | 1179.36999500 | 5271 | 364 | 6 | 1544-1179 | 364.88999960 | 365 |