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

select user_id
,count(user_id) visit_nums
from (select distinct visit_time
    ,o.user_id
    from order_tb o join visit_tb v on o.user_id=v.user_id
    where order_time like "2022-09-02%" and visit_time like "2022-09-02%") t
group by user_id
order by visit_nums desc