Order count per user

Order count per user

From sales(id, user_id, product, amount, ts) count how many order rows belong to each user. Group by user_id and return columns user_id and orders (number of rows). Order by user_id ascending.

Exemplo de resposta esperada

user_idorders
104
203
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid