By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
6 rows affected
| trip_id | segment_id | trip_timestamp | trip_distance | foot | bike | bus | car |
|---|---|---|---|---|---|---|---|
| 535521 | 2 | 2016-04-08 13:56:41 | 9008.23 | f | f | f | t |
| 536625 | 8 | 2016-04-11 17:38:02 | 9821.37 | t | f | f | f |
| 536624 | 1 | 2016-04-11 14:23:20 | 1872.41 | t | f | f | f |
| 537733 | 3 | 2016-04-13 13:19:49 | 14967.96 | t | f | t | f |
| 536623 | 0 | 2016-04-11 10:08:32 | 8244.27 | f | f | t | f |
| 544627 | 5 | 2016-04-25 11:24:37 | 3648.63 | f | t | f | f |
| trip_id | segment_id | trip_timestamp | trip_distance | foot | bike | bus | car |
|---|---|---|---|---|---|---|---|
| 536624 | 1 | 2016-04-11 14:23:20 | 1872.41 | t | f | f | f |