题解 | 商品价格排名

with temp as (
    select
    product_id,
    product_name,
    type,
    price,
    rank() over(partition by type order by price desc ) as rnk
    from product_info
)
select 
    product_id,
    product_name,
    type,
    price
    from temp 
    where rnk <= 2
    ORDER BY 
    price DESC, 
    product_name ASC
    limit 3
    

没读懂题目什么意思