Non-grouped column in SELECT

Question

Accepted Answer

Every column in SELECT must either appear in GROUP BY or be wrapped in an aggregate (SUM, MAX, etc.). When a dept has multiple employees, there's no single name that represents the group. Fix options: add name to GROUP BY (one row per dept+name combo), use MAX(name) to pick one name per dept, or remove name from SELECT.