By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| date | IssueId | Days_Open |
|---|---|---|
| 01/01/2012 00:00:00 | 1 | 0 |
| 02/01/2012 00:00:00 | 1 | 1 |
| 03/01/2012 00:00:00 | 1 | 2 |
| 03/01/2012 00:00:00 | 2 | 0 |
| 04/01/2012 00:00:00 | 1 | 3 |
| 04/01/2012 00:00:00 | 2 | 1 |
| 05/01/2012 00:00:00 | 1 | 4 |
| 05/01/2012 00:00:00 | 2 | 2 |
| 06/01/2012 00:00:00 | 2 | 3 |