By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| name | date_from | date_to | age |
|---|---|---|---|
| Alice | 2004-12-01 | 2005-12-01 | 35 |
| Alice | 2005-12-01 | 2006-12-01 | 36 |
| Alice | 2006-12-01 | 2007-12-01 | 37 |
| Alice | 2007-12-01 | 2008-12-01 | 38 |
| Alice | 2008-12-01 | 2008-04-03 | 39 |
| Bob | 2013-02-04 | 2014-02-04 | 43 |
| Bob | 2014-02-04 | 2015-02-04 | 44 |
| Bob | 2015-02-04 | 2014-11-04 | 45 |