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

select user_id,count(*) as visit_nums
from 
(

select 
    user_id,
    date(visit_time) as visit_date
from
    visit_tb
where
    user_id in (
        select
            user_id
        from
            order_tb
        where
            date(order_time) = '2022-09-02'
    )


) as A 
where visit_date = '2022-09-02'
group by user_id
order by count(*) desc