题解 | #某东618每一件商品的加购率#
某东618每一件商品的加购率
http://www.nowcoder.com/practice/f21d94fb283f4f6b82726ed0a9b0b266
select prd_id,round(sum(if_cart)/sum(if_vw),2) as cart_rate
from tb_clk_rcd
group by prd_id
order by prd_id
某东618每一件商品的加购率
http://www.nowcoder.com/practice/f21d94fb283f4f6b82726ed0a9b0b266
select prd_id,round(sum(if_cart)/sum(if_vw),2) as cart_rate
from tb_clk_rcd
group by prd_id
order by prd_id
相关推荐