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

select user_id,count(visit_time) as visit_nums
from visit_tb v 
where date(leave_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 count(visit_time) desc