By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1062721 rows affected
| id | device_id | created_at | val |
|---|---|---|---|
| 1 | 4 | 2020-01-01 00:05:27.280445 | 0 |
| 2 | 1 | 2020-01-01 00:03:57.986313 | 1 |
| 3 | 2 | 2020-01-01 00:03:10.407219 | 0 |
| 4 | 3 | 2020-01-01 00:04:29.211585 | 1 |
| 5 | 1 | 2020-01-01 00:06:52.405466 | 1 |
| 6 | 9 | 2020-01-01 00:08:26.874497 | 0 |
| 7 | 8 | 2020-01-01 00:08:13.420472 | 1 |
| 8 | 1 | 2020-01-01 00:07:24.344794 | 0 |
| 9 | 7 | 2020-01-01 00:12:36.898838 | 0 |
| 10 | 4 | 2020-01-01 00:11:48.993147 | 0 |
| 11 | 4 | 2020-01-01 00:10:09.613523 | 1 |
| 12 | 0 | 2020-01-01 00:14:44.678376 | 1 |
| 13 | 5 | 2020-01-01 00:12:18.083082 | 0 |
| 14 | 0 | 2020-01-01 00:13:28.476388 | 0 |
| 15 | 9 | 2020-01-01 00:14:50.968644 | 1 |