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.
Expected output sample
| user_id | views | purchases |
|---|---|---|
| 10 | 1 | 1 |
| 11 | 1 | 0 |
| 12 | 2 | 1 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid