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

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;