User activity: views and purchases

User activity: views and purchases

From the events table (columns user_id, event_type), for each user_id count views (number of 'view' events) and purchases (number of 'purchase' events). The event type is only ever 'view' or 'purchase'. Return user_id, views, purchases. Sort by user_id ascending.

A ordem das linhas importa

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid