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

select v.user_id,count(*) visit_nums
from visit_tb v
where date(visit_time)='2022-09-02'
group by v.user_id
having v.user_id in (
    select distinct user_id
    from order_tb o
    where date(o.order_time)='2022-09-02'
)
order by visit_nums desc