题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
SELECT
user_id,
COUNT(info_id) 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