题解 | 商品销售排名

with tiaojian as (
select 
lg.product_id,
type,
product_name,
sum(price) as py,
dense_rank()over(order by sum(price) desc,product_name asc) as pdiff
from user_client_log lg inner join product_info pf on 
lg.product_id=pf.product_id
where
step="select"
group by lg.product_id,type,product_name
)

select 
product_name,
cast(py as signed) as py
from tiaojian
where
pdiff<=2