Cheapest purchased product per user
Cheapest purchased product per user
In sales(id, user_id, product, amount, ts), for each user_id find the product with the lowest purchase amount and that minimal amount. Return columns user_id, cheapest_product, min_amount, ordered by user_id ascending.
Exemplo de resposta esperada
| user_id | cheapest_product | min_amount |
|---|---|---|
| 10 | Mouse | 25.00 |
| 20 | Cable | 10.00 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid