Distinct products per user
Distinct products per user
From the events table (columns user_id, product_id) count, for each user_id, the number of distinct product_id values. Return columns user_id and distinct_products. Order by user_id.
Exemplo de resposta esperada
| user_id | distinct_products |
|---|---|
| 10 | 1 |
| 11 | 1 |
| 12 | 1 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid