题解 | 查询下订单用户访问次数？

select
    user_id,
    count(distinct info_id) as visit_nums
from
    order_tb
    left join visit_tb using (user_id)
where
    date(order_time) = "2022-09-02"
    and datediff(visit_time, leave_time) = 0
    and date(visit_time) = "2022-09-02"
group by
    user_id
order by
    visit_nums desc