MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.
{
"type": "aggregation",
"collection": "orders",
"pipeline": [
{},
{},
{}
]
}$project — returns only productCount.$group — groups by null and aggregates averageCount.$project — returns only _id, averageCount._id: null groups the entire collection into a single result rather than grouping by a field.Live output from running this query against the sample dataset.
| averageCount |
|---|
| 1.2 |
Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.
Try it in the playground → No signup, runs in your browser.