题解 | 统计商家不同会员每日访问人次及访问人数

select
    b.vip vip, b.visit_nums visit_nums, c.visit_users visit_users
from
    (
        select
    vip, count(visit_time) visit_nums
from test.visit_tb vt join test.uservip_tb ut on vt.user_id = ut.user_id
group by vip

    ) b
join
        (
     select
    a.vip, count(a.vip) visit_users
from
    (
        select
    vip, vt.user_id
from test.visit_tb vt join test.uservip_tb ut on vt.user_id = ut.user_id
group by vip, vt.user_id
    ) a
group by a.vip
     ) c
on b.vip=c.vip
order by visit_nums desc, visit_users desc