Selecting Records from Non-Unique Id Tables Using SQL Join Types and Subqueries

How to Run Aggregate Functions on Grouped Records While Preserving Unique Values in SQL