Grouping

Group by

Kotlin

val customerCount = label<Int>()

CustomerTable
    .groupBy(CustomerTable.shop)
    .select(CustomerTable.shop, count() as_ customerCount)
    .perform(db)

SQL

SELECT T0."shop" c0
, COUNT(*) c1
FROM "Customer" T0
GROUP BY T0."shop"