Views and purchases per product
Views and purchases per product
From the events table (columns product_id, event_type), count for each product_id the number of 'view' events and 'purchase' events. Return product_id, views, purchases. Sort by product_id ascending.
Exemplo de resposta esperada
| product_id | views | purchases |
|---|---|---|
| 1 | 2 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 1 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid