By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| aid | bid | checkMonth | avalue |
|---|---|---|---|
| 1 | 4 | 2014-07-05 | 123.00 |
| 1 | 4 | 2014-08-01 | 467.00 |
| 1 | 4 | 2014-09-01 | 0.00 |
| 1 | 4 | 2014-10-01 | 0.00 |
| 1 | 4 | 2014-11-03 | 876.00 |
| 1 | 4 | 2014-12-01 | 876.00 |
| 2 | 6 | 2016-01-02 | 23.00 |
| 2 | 6 | 2016-02-01 | 0.00 |
| 2 | 6 | 2016-03-14 | 56.00 |
| 2 | 6 | 2016-04-17 | 98.00 |
| 2 | 6 | 2016-05-01 | 0.00 |
| 2 | 6 | 2016-06-01 | 0.00 |
| 2 | 6 | 2016-07-01 | 90.00 |