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

 # select user_id from order_tb  where order_time like '%2022-09-02%'
select
    user_id,
    count(user_id) as visit_nums
from
    visit_tb
where
    user_id in (
        select
            user_id
        from
            order_tb
        where
            order_time like '%2022-09-02%'
    )
    and visit_time like '2022-09-02%'
    and leave_time like '2022-09-02%'
group by
    user_id
order by
    visit_nums desc