By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 8 Duplicates: 0 Warnings: 0
Records: 12 Duplicates: 0 Warnings: 0
id | project_id | item | quantity | dt_start | dt_END | itm_sum |
---|---|---|---|---|---|---|
4 | 5678 | table | 025 | 2021-01-12 10:00:00 | 2021-01-15 10:00:00 | 35 |
5 | 5678 | light | 003 | 2021-01-12 10:00:00 | 2021-01-15 10:00:00 | 13 |
6 | 9876 | table | 010 | 2021-01-10 10:00:00 | 2021-01-14 10:00:00 | 35 |
7 | 9876 | chair | 100 | 2021-01-10 10:00:00 | 2021-01-14 10:00:00 | 100 |
8 | 2323 | light | 010 | 2021-01-12 10:00:00 | 2021-01-15 10:00:00 | 13 |