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

select
    vt.user_id user_id,
    count(distinct visit_time) visit_nums
from
    test.order_tb ot
    join test.visit_tb vt on ot.user_id = vt.user_id
    and day (order_time) = 2
where
    day (visit_time) = 2
group by
    vt.user_id
order by
    visit_nums desc