题解 | 查询下订单用户访问次数?
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