题解 | 查询下订单用户访问次数？
不明白为什么这么写输出的和答案不一样，答案多了一条user_id=10的数据
select user_id
, count(user_id) visit_nums
from visit_tb
where user_id in
(select user_id from order_tb
where left(trim(order_time),10) = "2022-09-02")
and left(trim(visit_time),10) = "2022-09-02"
and left(trim(leave_time),10) = "2022-09-02"
group by user_id
order by visit_nums desc;
查看12道真题和解析