One comparison on an aggregate's result — SQL's HAVING. field names a metric by its as name: "MGAs with more than five markets" is markets grouped by MGA, counted, and kept where the count is over five.
field
as
A metric's as name.
A number, or [low, high] for between.
[low, high]
between
One comparison on an aggregate's result — SQL's HAVING.
fieldnames a metric by itsasname: "MGAs with more than five markets" is markets grouped by MGA, counted, and kept where the count is over five.