By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Id | ComputerName | TimestampOrigin | Timestamp | Number |
---|---|---|---|---|
1 | Computer1 | 2021-02-10 12:00:00 | 2021-02-27 12:00:00 | 35 |
2 | Computer2 | 2021-02-10 12:00:00 | 2021-02-27 12:00:00 | 24 |
3 | Computer3 | 2021-02-09 12:00:00 | 2021-02-26 12:00:00 | 23 |
3 | Computer4 | 2021-02-09 12:00:00 | 2021-02-26 12:00:00 | null |
4 | Computer5 | 2021-02-08 12:00:00 | 2021-02-25 12:00:00 | 7 |
5 | Computer6 | 2021-02-08 12:00:00 | 2021-02-25 12:00:00 | 0 |
7 | Computer7 | 2021-02-07 12:00:00 | 2021-02-24 12:00:00 | 9 |
TimestampOrigin | Less1 | Less10 | Less25 |
---|---|---|---|
2021-02-10 | 0 | 0 | 1 |
2021-02-09 | 0 | 0 | 2 |
2021-02-08 | 1 | 2 | 2 |
2021-02-07 | 1 | 3 | 2 |