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.

Exemplo de resposta esperada

user_idviewspurchases
1011
1110
1221
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid