拼多多寻梦批

image.png
select (distinct user_id)
from user_ord
where datediff(now(),ord_time)<=30
group by user_id
having sum(ord_amt)>5000
image.png
select new.user_type ,avg(new.pv_cnt) as avg_visit_by_type
from(select user_id,user_type,pv_cnt,cume_dist() over(partition by user_type order by pv_cnt )  percent
from user_visits) new
where new.percent>0.05
image.png

image.png
select mall_no,count_ord,count_good,count_user,rank() over(order by new.count_ord desc) as ord_rank)
(select mall_no,count(if(datediff(now(),order_time<20,1,0)) count_ord,count(distinct mall_good.good_no) count_good,count(distinct user_id) as count_user
from mall_goods left join order on mall_goods.goods_no=order.goods_no
group by mall_no) new

第四题
有三个袋子,一号袋子3红球7黑球,二号袋子8红2黑,三号袋子4红6黑,随机选一个袋子并从中取一个球,如果拿出红球,那么这个球来自三号袋子的概率 。
第五题
超市昨天的成交金额突然降了,怎么找到原因

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容