By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 8
| id | dt | previous_wednesday | previous_thursday | dy | trunc_week | down |
|---|---|---|---|---|---|---|
| 1 | 2024-01-15 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 | mon | 2024-01-15 00:00:00+00 | 1 |
| 2 | 2024-01-16 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 | tue | 2024-01-15 00:00:00+00 | 2 |
| 3 | 2024-01-17 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 | wed | 2024-01-15 00:00:00+00 | 3 |
| 4 | 2024-01-18 | 2024-01-17 00:00:00+00 | 2024-01-11 00:00:00+00 | thu | 2024-01-15 00:00:00+00 | 4 |
| 5 | 2024-01-19 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 | fri | 2024-01-15 00:00:00+00 | 5 |
| 6 | 2024-01-20 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 | sat | 2024-01-15 00:00:00+00 | 6 |
| 7 | 2024-01-21 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 | sun | 2024-01-15 00:00:00+00 | 0 |
| 8 | 2024-01-22 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 | mon | 2024-01-22 00:00:00+00 | 1 |
SELECT 8