Filtering out duplicates within a CTE

The data in this cte looks like this:

Removing duplicates within a CTE

The data in this cte looks like this: