Hi

I would like to understand your data a little better before attempting to advise you on the query to solve your problem.

The data seems to include a repeating group of IDs 1, 2 and 3. IDs 1 and 2 seem to be OLD, while ID 3 is new. Is this a consistent pattern?

Cheers