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
全部评论
相关推荐
12-03 15:50
天津理工大学 Unity3D客户端 点赞 评论 收藏
分享
