题解 | 输出在5min内完成点击购买的用户ID
select c.user_id uid from user_ad_click_time c left join user_payment_time p on c.trace_id=p.trace_id and c.user_id=p.user_id where timestampdiff (minute, c.click_time, p.pay_time)<=5 order by uid desc
select c.user_id uid from user_ad_click_time c left join user_payment_time p on c.trace_id=p.trace_id and c.user_id=p.user_id where timestampdiff (minute, c.click_time, p.pay_time)<=5 order by uid desc
相关推荐