题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

select
    product_id,
    product_name,
    category_id,
    sales_amount,
    profit_rate
from
    (
        select
            p.product_id as product_id,
            product_name,
            category_id,
            sales_amount,
            row_number() over (
                partition by
                    category_id
                order by
                    sales_amount desc
            ) as sales_rank,
            round((sales_amount - cost_amount) / sales_amount, 2) as profit_rate
        from
            product_category as p
            inner join sales_and_profit as s on p.product_id = s.product_id
    ) as rk
where
    sales_rank <= 3
    and profit_rate >= 0.2
order by
    category_id asc,
    sales_amount desc,
    product_id asc;