Working with Aggregations

1. Counting Records

const active = await prisma.user.count({ where: { active: true } });

Form	Returns
`count(args)`	Number
`count({ select: { id: true, email: true } })`	Per-field non-null counts

const { _sum } = await prisma.order.aggregate({ _sum: { total: true } });

Aspect	Detail
Numeric only	Int, Float, Decimal, BigInt
Decimal	Result is `Prisma.Decimal`

Aspect	Detail
`_avg`	Returns Float (or Decimal)
Null rows	Excluded from average

Aspect	Detail
`_min`	Works on Int, Float, Decimal, DateTime, String

Aspect	Detail
`_max`	Symmetric to `_min`

await prisma.order.groupBy({
  by: ["status"],
  _sum: { total: true },
  _count: { _all: true }
});

await prisma.order.groupBy({
  by: ["status"],
  _sum: { total: true },
  having: { total: { _sum: { gt: 1000 } } }
});

Aspect	Detail
HAVING	Applied after aggregation

Approach	Detail
`_count` in include	Cheap relation counts
Raw SQL	Required for SUM/AVG of relations

Use	Detail
`groupBy` + `by`	Equivalent of distinct
Raw COUNT(DISTINCT)	Use `$queryRaw`