题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select a.user_id,count(distinct b.visit_time) as visit_nums from order_tb a left join visit_tb b on a.user_id=b.user_id where date(a.order_time)='2022-09-02' and date(b.visit_time)='2022-09-02' group by a.user_id order by visit_nums DESC
查看15道真题和解析