题解 | 统计商家不同会员每日访问人次及访问人数
with all_tmp as ( select t1.*,t2.vip,t2.point from visit_tb as t1 left join uservip_tb as t2 on t1.user_id = t2.user_id) select t.vip ,count(t.info_id) as visit_nums ,count(distinct user_id) as visit_users from all_tmp as t group by t.vip order by visit_nums desc;
先将两个表合并，然后想干嘛就干嘛！
投递数字马力等公司7个岗位
和你一样我还是学院本，丸辣