题解 | #输出在5min内完成点击购买的用户ID#
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
用户id会有重复,而trace_id没有重复。
SELECT DISTINCT U1.user_id uid FROM user_ad_click_time U1 JOIN user_payment_time U2 WHERE TIMESTAMPDIFF(MINUTE,click_time ,pay_time ) <5 AND U1.trace_id =U2.trace_id ORDER BY uid