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

Using Case Statements to Filter Groups with Having Clauses in SQL