By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 20 Duplicates: 0 Warnings: 0
| dt | cntClientsGt5time30day |
|---|---|
| 2024-08-04 | 2 |
| 2024-08-09 | 1 |
| 2024-08-10 | 1 |
| 2024-08-11 | 1 |
| 2024-08-12 | 1 |
| 2024-08-27 | 1 |
| 2024-09-08 | 1 |
| 2024-09-19 | 0 |
| 2024-10-01 | 0 |
| client_id | dt | cntClientDay | cntClientLast30day |
|---|---|---|---|
| 8225501 | 2024-08-04 | 5 | 5 |
| 9609244 | 2024-08-04 | 6 | 6 |
| 8225501 | 2024-08-09 | 1 | 6 |
| 8225501 | 2024-08-10 | 1 | 7 |
| 8225501 | 2024-08-11 | 1 | 8 |
| 8225501 | 2024-08-12 | 1 | 9 |
| 8225501 | 2024-08-27 | 1 | 10 |
| 8225501 | 2024-09-08 | 1 | 6 |
| 9609244 | 2024-09-08 | 1 | 1 |
| 8225501 | 2024-09-19 | 1 | 3 |
| 8225501 | 2024-10-01 | 1 | 3 |
| client_id | dt | cntClientDay |
|---|---|---|
| 8225501 | 2024-08-04 | 5 |
| 9609244 | 2024-08-04 | 6 |
| 9609244 | 2024-09-08 | 1 |
| 8225501 | 2024-08-09 | 1 |
| 8225501 | 2024-08-10 | 1 |
| 8225501 | 2024-08-11 | 1 |
| 8225501 | 2024-08-12 | 1 |
| 8225501 | 2024-08-27 | 1 |
| 8225501 | 2024-09-08 | 1 |
| 8225501 | 2024-09-19 | 1 |
| 8225501 | 2024-10-01 | 1 |
| client_id | timestamp | dttm |
|---|---|---|
| 8225501 | 1722747654 | 2024-08-04 05:00:54 |
| 8225501 | 1722747683 | 2024-08-04 05:01:23 |
| 9609244 | 1722747693 | 2024-08-04 05:01:33 |
| 9609244 | 1722757693 | 2024-08-04 07:48:13 |
| 9609244 | 1722767693 | 2024-08-04 10:34:53 |
| 9609244 | 1722777693 | 2024-08-04 13:21:33 |
| 9609244 | 1722787693 | 2024-08-04 16:08:13 |
| 9609244 | 1722797693 | 2024-08-04 18:54:53 |
| 9609244 | 1725797693 | 2024-09-08 12:14:53 |
| 8225501 | 1722757683 | 2024-08-04 07:48:03 |
| 8225501 | 1722767683 | 2024-08-04 10:34:43 |
| 8225501 | 1722777683 | 2024-08-04 13:21:23 |
| 8225501 | 1723177683 | 2024-08-09 04:28:03 |
| 8225501 | 1723277683 | 2024-08-10 08:14:43 |
| 8225501 | 1723377683 | 2024-08-11 12:01:23 |
| 8225501 | 1723477683 | 2024-08-12 15:48:03 |
| 8225501 | 1724777683 | 2024-08-27 16:54:43 |
| 8225501 | 1725777683 | 2024-09-08 06:41:23 |
| 8225501 | 1726777683 | 2024-09-19 20:28:03 |
| 8225501 | 1727777683 | 2024-10-01 10:14:43 |