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_id | views | purchases |
|---|---|---|
| 10 | 1 | 1 |
| 11 | 1 | 0 |
| 12 | 2 | 1 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid