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_idcheapest_productmin_amount
10Mouse25.00
20Cable10.00
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid