题解 | #输出在5min内完成点击购买的用户ID#
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
SELECT
click.user_id AS uid
FROM
user_ad_click_time click
INNER JOIN
user_payment_time payment
ON
payment.user_id = click.user_id
AND payment.trace_id = click.trace_id -- 确保支付和点击记录是匹配的
WHERE
TIMESTAMPDIFF(MINUTE, click.click_time, payment.pay_time) <= 5 -- 时间差小于等于5分钟
ORDER BY
click.user_id DESC
;
阿里云成长空间 760人发布