Умеешь ли писать сложные SQL запросы

WITH ranked_sales AS (
    SELECT 
        product_id,
        sale_date,
        amount,
        RANK() OVER (PARTITION BY product_id ORDER BY amount DESC) as sales_rank
    FROM sales
)
SELECT 
    p.name,
    r.sale_date,
    r.amount
FROM ranked_sales r
JOIN products p ON r.product_id = p.id
WHERE r.sales_rank <= 3;