select product_id,product_name,type,price
from 
(select *,dense_rank()over(partition by type order by price desc) rk 
from product_info) m
where rk<=2
order by price desc,product_name
limit 3;
JD题目总是给人一种表述不清楚的感觉