题解 | 查询下订单用户访问次数？
select distinct user_id, count(distinct visit_time) as visit_nums from visit_tb left join order_tb using(user_id) where date(order_time) = '2022-09-02' and date(visit_time) = '2022-09-02' group by user_id order by visit_nums desc
distinct的用法
