By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
min(date_before) | count(date_c)+1 | month | year |
---|---|---|---|
1982-01-10T00:00:00Z | 2 | 01 | 1982 |
1985-01-16T00:00:00Z | 2 | 01 | 1985 |
1987-01-11T00:00:00Z | 3 | 01 | 1987 |