Most expensive purchased product per user

Most expensive purchased product per user

In sales(id, user_id, product, amount, ts), for each user_id find the product with the highest purchase amount and that amount itself. Return columns user_id, top_product, max_amount, ordered by user_id ascending.

Expected output sample

user_idtop_productmax_amount
10Monitor300.00
20Laptop1200.00
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid