题解 | 查询下订单用户访问次数？
select v.user_id,count(*) visit_nums
from visit_tb v
where date(visit_time)='2022-09-02'
group by v.user_id
having v.user_id in (
select distinct user_id
from order_tb o
where date(o.order_time)='2022-09-02'
)
order by visit_nums desc
腾讯云智研发成长空间 5088人发布
