Latest Record per Entity

Return the latest price of every product (product, price). Order by product.

Table schema

Prices(product VARCHAR(20), price INT, updated_at DATE)

Sample data

product | price | updated_at
Pen | 10 | 2026-01-01
Pen | 12 | 2026-02-01
Book | 50 | 2026-01-15