题解 | 查询下订单用户访问次数？
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
查看28道真题和解析
