题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
SELECT
user_id,
COUNT(info_id) AS visit_nums
FROM visit_tb
# ON order_tb.user_id = visit_tb.user_id
WHERE visit_tb.user_id IN (
SELECT
DISTINCT user_id
FROM order_tb
WHERE order_time LIKE '2022-09-02%'
)
AND visit_time LIKE '2022-09-02%'
AND leave_time LIKE '2022-09-02%'
GROUP BY visit_tb.user_id
ORDER BY visit_nums DESC
投递字节跳动等公司7个岗位 >
虽然我也是抄的
