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

select
        vtb.user_id,
        count(visit_time) as visit_nums
from (
    select
        distinct user_id
    from 
            order_tb
    where 
            substr(order_time,1,10) = '2022-09-02'
) as otb
left join
        visit_tb as vtb
on 
        otb.user_id = vtb.user_id
where 
        visit_time < leave_time
and 
        substr(visit_time,1,10) = '2022-09-02'
group by 
        vtb.user_id
order by 
        visit_nums desc