By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| dt | prevWednesday | prevThursday |
|---|---|---|
| 2024-01-10 00:00:00+00 | 2024-01-03 00:00:00+00 | 2024-01-04 00:00:00+00 |
| 2024-01-11 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-04 00:00:00+00 |
| 2024-01-12 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-13 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-14 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-15 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-16 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-17 00:00:00+00 | 2024-01-10 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-18 00:00:00+00 | 2024-01-17 00:00:00+00 | 2024-01-11 00:00:00+00 |
| 2024-01-19 00:00:00+00 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
| 2024-01-20 00:00:00+00 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
| 2024-01-21 00:00:00+00 | 2024-01-17 00:00:00+00 | 2024-01-18 00:00:00+00 |
SELECT 12