题解 | 查询下订单用户访问次数？
-- 下订单用户访问次数
-- 虽然很烂，还是记录一下
select
user_id, count(visit_time) as visit_nums
from
visit_tb
where user_id in (
select user_id from order_tb where date(order_time)='2022-09-02'
) and date(visit_time)='2022-09-02'
group by user_id
order by visit_nums desc
查看13道真题和解析
华为工作强度 966人发布