题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select
ot.user_id,
count(distinct vt.visit_time) as visit_nums
from
order_tb ot
left join
visit_tb vt on ot.user_id = vt.user_id and date(ot.order_time) = date(vt.visit_time)
where
date(ot.order_time) = '2022-09-02'
group by
1
order by
2 desc
#牛友打假中心#
汤臣倍健公司氛围 419人发布