Retrieving the Next Step in a Process Using SQL Joins and Group By Clause

How to Remove Matching Rows Between Aggregated and Non-Aggregated Columns Using CTEs