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

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