By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
21 rows affected
| aDate | isBusinessDay | realRate | UseThisRate |
|---|---|---|---|
| 2022-04-01 | True | 1.10 | 1.10 |
| 2022-04-02 | True | 1.20 | 1.20 |
| 2022-04-03 | True | 1.30 | 1.30 |
| 2022-04-04 | False | 1.40 | 1.30 |
| 2022-04-05 | False | 1.50 | 1.30 |
| 2022-04-06 | True | 1.60 | 1.60 |
| 2022-04-07 | True | 1.70 | 1.70 |
| 2022-04-08 | True | 1.80 | 1.80 |
| 2022-04-09 | True | 1.90 | 1.90 |
| 2022-04-10 | False | 2.00 | 1.90 |
| 2022-04-11 | False | 2.10 | 1.90 |
| 2022-04-12 | False | 2.20 | 1.90 |
| 2022-04-13 | False | 2.30 | 1.90 |
| 2022-04-14 | True | 2.40 | 2.40 |
| 2022-04-15 | True | 2.50 | 2.50 |
| 2022-04-16 | True | 2.60 | 2.60 |
| 2022-04-17 | True | 2.70 | 2.70 |
| 2022-04-18 | False | 2.80 | 2.70 |
| 2022-04-19 | False | 2.90 | 2.70 |
| 2022-04-20 | False | 3.00 | 2.70 |
| 2022-04-21 | False | 3.10 | 2.70 |