As for your GROUPing issue, yes, much like formulas in a saved search, you can’t combine aggregates with non-aggregates. Everything doesn’t necessarily need to be in the

GROUP BY

clause, but will at least need to have some other form of aggregation, like

COUNT()

,

MIN()

,

MAX()

, etc.