Which SELECT is valid with GROUP BY dept?

Question

Accepted Answer

With GROUP BY dept, only dept can appear outside an aggregate in SELECT. COUNT(*) and MAX(salary) are aggregate functions, so they are valid alongside dept. The other options include name or id without wrapping them in aggregates - both would be ambiguous because multiple names or ids can exist per dept group.