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

第一种：使用adddate函数，click_time加5分钟，超过pay_time则在五分钟内支付的

select u.user_id uid
from user_ad_click_time u
left join user_payment_time p using(user_id,trace_id)
where adddate(click_time,interval 5 minute) > pay_time
order by uid desc

第二种：使用timestampdiff直接计算时间差，结果小于5分钟则满足

select u.user_id uid
from user_ad_click_time u
left join user_payment_time p using(user_id,trace_id)
where timestampdiff(minute,click_time,pay_time) < 5
order by uid desc