全部评论
上面那个放进SQL有点问题,下面这一段可以跑出来: select p1.月份,p1.seller_name from ( select '2019M5' as 月份, seller_name,sum(gmv) as sum from purchase where month(dt)=5 group by seller_name order by sum limit 50) p1 union select p2.月份,p2.eller_name from ( select '2019M6' as 月份, seller_name,sum(gmv) as sum from purchase where month(dt)=6 group by seller_name order by sum limit 50) p2;
分享
用个union all就好了啊。先选出5月份的店铺,union all 6月的店铺
分享
联想
官网直投
不会,哭了,感觉那个50%不知道怎么界定,是gmv从大到小排完序后吗,没太想通。
分享
那个50%。我自己想的每个月里面GMV最高的前50名(因为它说有100个店铺)
分享
请问ABtest那道题该怎么写思路啊?
分享
呜呜呜 没来的及写完。我思路是先casewhen 把五月六月数据挑出来,再sum(gmv),rank sum,取前一半,记得group by seller_name。没写完哭哭,有么有大神更简洁的思路😂
分享
题目咋说来着,好像是gmv 前50%,感觉题目表述的不是很清楚,到底是(贡献了前50%gmv的还是gmv的排名50%) 我写的是gmv倒序累加起来<=当月总gmv*50%(也就是贡献了前50%gmv)
分享
想问如何 写那个时间转换的啊 提出来的数据是2016M5
分享
那道SQL题多少分啊
分享
请问下简答题也就是最后一题,没有保存系统是不是不会自动保存……
分享
我在考试结束后写出来了
分享
Select top 50 (a.yuefen, a.seller_name) from (select concat(‘2019M’, month(dt)) as ‘yuefen’, seller_name, sum(gmv) as total From purchase Where month(dt) = 5 Group by seller_name order by total desc) as a Union all Select top 50 (b.yuefen, b.seller_name) from (select concat(‘2019M’, month(dt)) as ‘yuefen’, seller_name, sum(gmv) as total From purchase Where month(dt) = 6 Group by seller_name order by total desc) as b; 我综合了大佬们的发言,把我的代码发出来了,不知道能不能这样写,欢迎大佬们来指正。
分享
select 月份,seller_name from ( select '2019M5' as '月份', seller_name,sum(gmv) as sum from purchase where datepart(m,dt)=5 group by seller_name order by sum limit 50) union select 月份,seller_name from ( select '2019M6' as '月份', seller_name,sum(gmv) as sum from purchase where datepart(m,dt)=6 group by seller_name order by sum limit 50) ; 不晓得对不对
分享
相关推荐