How to Remove Duplicate Rows in SQL Using Common Table Expressions (CTEs)

Creating a New SQL Table with Unique ID Duplicates