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_iddistinct_products
101
111
121
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid