Say I have the following data set. I want to be able to group based upon the wrap up date. Wrap up signals the end of a group.

Screenshot 2023-04-17 105922.png


In other words I want to produce the following data but I can't get the SQL right. I am using db2 DSN12015.

Screenshot 2023-04-17 110004.png