select
SUBSTRING_INDEX(amt.user_name,',',1) as user_name1,
COUNT(amt.user_name) as number
from(
select
device_id,
SUBSTRING_INDEX(profile,',',-2) as user_name
from user_submit
) as amt group by amt.user_name
SUBSTRING_INDEX(amt.user_name,',',1) as user_name1,
COUNT(amt.user_name) as number
from(
select
device_id,
SUBSTRING_INDEX(profile,',',-2) as user_name
from user_submit
) as amt group by amt.user_name
我已经通过这道题!
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fb8d8a87fe1fc415c96f355dc62bdd12f
全部评论
相关推荐
__我爱学习__:学到了,大佬
帮你内推|拼多多集团-PDD 实习 点赞 评论 收藏
分享
02-27 11:14
河北工业大学 C++ 点赞 评论 收藏
分享
远航_随风:感谢大佬的面经,这个拷打的很深入啊。我当时挂的京东一面也是面了半个小时没手撕,但是是KPI面,和别人在同一个部门问到的问题基本差不多。加油
查看29道真题和解析 点赞 评论 收藏
分享