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.
Expected output sample
| user_id | distinct_products |
|---|---|
| 10 | 1 |
| 11 | 1 |
| 12 | 1 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid