题解 | 输出在5min内完成点击购买的用户ID
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
select
distinct t1.user_id as uid
from
user_ad_click_time t1
join
user_payment_time t2
on t1.user_id = t2.user_id and t1.trace_id = t2.trace_id
where
TIMESTAMPDIFF(MINUTE, t1.click_time, t2.pay_time) <= 5
order by uid;