By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| id | month | year | length_in_month |
|---|---|---|---|
| 1 | 10 | 2014 | 1 |
| 1 | 11 | 2014 | 2 |
| 1 | 12 | 2014 | 3 |
| 2 | 9 | 2014 | 1 |
| 2 | 10 | 2014 | 2 |
| 2 | 1 | 2015 | 5 |
8 rows affected
| id | month | year | length_in_month |
|---|---|---|---|
| 1 | 10 | 2014 | 1 |
| 1 | 11 | 2014 | 2 |
| 1 | 12 | 2014 | 3 |
| 2 | 9 | 2014 | 1 |
| 2 | 10 | 2014 | 2 |
| 2 | 1 | 2015 | 5 |