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

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