#1142

Average order value

Compute the average order value — the average amount over purchase events (kind = purchase), rounded to two decimals. Return a single column aov, one row.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

aov
27.5

Your query result will appear here