Count how many teams are on each plan

MongoDB query compiled from plain English against the saasUsers sample schema, then verified by running it.

The compiled query

{
  "type": "aggregation",
  "collection": "teams",
  "pipeline": [
    {},
    {}
  ]
}

How the compiled query works

$group — groups by "$plan" and aggregates count.
$project — returns only plan, count, _id.

Things worth knowing

Inside $group, count counts documents in each group — one output document per distinct "$plan".

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.

Count how many teams are on each plan

The compiled query

How the compiled query works

Things worth knowing

Related queries