题解 | #输出在5min内完成点击购买的用户ID#
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
select distinct
t1.user_id as uid
from
user_ad_click_time as t1
inner join user_payment_time as t2 on t1.trace_id = t2.trace_id
where
date_add(t1.click_time, interval 5 minute) > t2.pay_time
order by
uid desc;
顺丰集团工作强度 369人发布
