By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 15
| year | ?column? | array_agg |
|---|---|---|
| 2018 | 25 | {2018-12-10,2018-12-15,2018-12-16,2018-12-18,2018-12-21} |
| 2019 | 1 | {2019-01-08,2019-01-12,2019-01-16} |
| 2018 | 24 | {2018-12-02,2018-12-04,2018-12-05} |
| 2019 | 0 | {2019-01-02,2019-01-05} |
| 2018 | 26 | {2018-12-25,2018-12-30} |
SELECT 5