题解 | #输出在5min内完成点击购买的用户ID#

-- trace_id为主键
select t1.user_id as uid
from  user_ad_click_time t1
join user_payment_time  t2
on t1.trace_id = t2.trace_id
where timestampdiff(minute,t1.click_time, t2.pay_time) < 5
order by t1.user_id desc