By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| Item | City | Start_Y | Start_W | First_Use_Y | First_Use_W | Value |
|---|---|---|---|---|---|---|
| A | NEW YORK | 2023 | 30 | 2023 | 30 | 0 |
| A | NEW YORK | 2023 | 30 | 2023 | 31 | 0 |
| A | NEW YORK | 2023 | 30 | 2023 | 32 | 15000 |
| A | NEW YORK | 2023 | 30 | 2023 | 33 | 0 |
| A | NEW YORK | 2023 | 30 | 2023 | 34 | 0 |
| A | LONDON | 2024 | 2 | 2024 | 2 | 12000 |
| A | LONDON | 2024 | 2 | 2024 | 3 | 0 |
| A | LONDON | 2024 | 2 | 2024 | 4 | 0 |
| A | LONDON | 2024 | 2 | 2024 | 5 | 50000 |
| A | LONDON | 2024 | 2 | 2024 | 6 | 0 |
| B | NEW YORK | 2023 | 49 | 2023 | 49 | 0 |
| B | NEW YORK | 2023 | 49 | 2023 | 50 | 0 |
| B | NEW YORK | 2023 | 49 | 2023 | 51 | 0 |
| B | NEW YORK | 2023 | 49 | 2023 | 52 | 0 |
| B | NEW YORK | 2023 | 49 | 2024 | 1 | 19540 |
| B | MADRID | 2023 | 10 | 2023 | 10 | 0 |
| B | MADRID | 2023 | 10 | 2023 | 11 | 15444 |
| B | MADRID | 2023 | 10 | 2023 | 12 | 0 |
| B | MADRID | 2023 | 10 | 2023 | 13 | 0 |
| B | MADRID | 2023 | 10 | 2023 | 14 | 0 |