数据分析笔试
第二道编程题一直错误，跪求大佬看看错误原因
select num1 ,if(num2 is null ,0 ,num2)
from(select * from
(select product ,count(distinct user_id) as num1
from t_user_login
group by product)a
left join
(select count(distinct user_id) as num2
from t_user_login
where user_id like '%NetEase%'
group by product
)b
on a.product = b.product
)
全部评论
(3) 回帖