The following union statement is creating seperate line items for the same year. I would
like to have distinc years with all the info on a single line instead on multiple entries.
I also tried using row_numder , and dense rank however the same issue
2001 2, null
2001 null, 4
I would like everything on a single line