Compare two version results and display in different sections

Hi All,

In database table, i have one field called 'versions' which will be captured from agent run. So when the agent runs, it will give some array of outputs for each version like below,

1st time run Output

{workId - 1, decision - need referal, status - pass}

{workId - 2, decision - no referral, status - pass}

{workId - 3 , decision - need referral, status - pass}

2nd time run Output:

{workId - 1, decision - no referal, status - pass}

{workId - 2, decision - need referral, status - pass}

{workId - 3 , decision - need referral, status - pass}

{workId - 4 , decision - need referral, status - pass}

So, now I have to compare workIds result between 1st run output and 2nd run output and have to show below 3 sections,

Section 1: New Referral - which will have the workIds which needs referral in output 2 but not in output 1, so from above example it should be below rows from output2,

{workId - 2, decision - need referral, status - pass}

{workId - 4 , decision - need referral, status - pass}

Section 2: Existing Referral Still Required - which will have the workIds which needs referral in both output 2 and output 1, so from above example it should be below rows from output2,

{workId - 3 , decision - need referral, status - pass}

Section 3: Existing Referral No longer required - which will have the workIds which says, 'No referral' in output 2 but 'Need Referral' in output 1, so from above example it should be below rows from output2,

{workId - 1, decision - no referal, status - pass}

Please help me on this