Valid fix for non-grouped column

Question

Accepted Answer

The problem is name - it is not in GROUP BY and not wrapped in an aggregate. The cleanest fix is to remove name from the SELECT list so every remaining column is either in GROUP BY or aggregated. If you actually need a name alongside the max salary, you would add name to GROUP BY (changing the grouping) or use a subquery. The other options do not resolve the invalid column reference.