How to Avoid Duplicate Rows with Left Outer Join and Group By Clause in SQL Server

Left Joining Twice on the Same Table with Multiple IDs Using SQL and Common Table Expressions (CTEs)