Aggregates

The :agg operator permits the use of aggregate functions, such as count, sum and so on. See below for a listing of what you can do.

Stats

• max the max val by some expr.
• min the min val by some expr.
• rel/max-by the max row by some expr.
• rel/min-by the min row by some expr.

Top or bottom N

• rel/bottom find the lowest n vals for some expr.
• rel/bottom-by find the lowest n rows for some expr.
• rel/top find the biggest n vals for some expr.
• rel/top-by find the biggest n rows for some expr.

Counts

• count row count, or row count for all rows meeting some predicate.
• rel/count-distinct val count for all distinct vals of some expr.

Other

• rel/any / rel/not-any check if any row meets a predicate (or not).
• rel/sum sum over some expr.
• rel/set-concat build sets by some expr over grouped rows.