代码
select
a.user_id as uid
from user_ad_click_time a
join user_payment_time b on a.trace_id=b.trace_id
where timestampdiff(minute,a.click_time,b.pay_time)<5
order by a.user_id desc
知识点
timestampdiff函数
用法: timestampdiff(unit,begin,end)计算两个日期的差值,end-begin
unit是确定结果的单位,可以精确到天(day),分钟(minute),秒(second),时(hour)