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.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid