O'Reilly logo
  • Gary Whitten thinks this is interesting:

When you are using GROUP BY, the SELECT clause can only include the fields you are grouping by or the aggregates. If we want to see the names in the output, we need to include them in the fields we are grouping by. This guards against cases where there might be different names for one MemberID