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 没读懂题目什么意思