Please provide sample DDL, INSERT statements and desired results (based on the sample data provided) if you would like people to provide a working solution.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin