Cool, thanks for all the above suggestions

I see. That makes sense. A colleague gave me a query that had a case expression (see below), and thinking about it further, it doesn't really make sense to group by...