By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
27 rows affected
| FromDate | ThruDate | ExpenseType | SumAmount | AvgSumAmount |
|---|---|---|---|---|
| 2020-04-01 00:00:00.000 | 2020-09-30 00:00:00.000 | 2 | 200.00 | 183.333333 |
| 2020-04-01 00:00:00.000 | 2020-09-30 00:00:00.000 | 3 | 250.00 | 183.333333 |
| 2020-10-01 00:00:00.000 | 2021-03-31 00:00:00.000 | 2 | 1200.00 | 1100.000000 |
| 2020-10-01 00:00:00.000 | 2021-03-31 00:00:00.000 | 3 | 1500.00 | 1100.000000 |
| 2021-04-01 00:00:00.000 | 2021-09-30 00:00:00.000 | 2 | 400.00 | 366.666666 |
| 2021-04-01 00:00:00.000 | 2021-09-30 00:00:00.000 | 3 | 500.00 | 366.666666 |