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

select user_ad_click_time.user_id uid

from user_ad_click_time,user_payment_time

where user_ad_click_time.user_id=user_payment_time.user_id

and

(date(pay_time-click_time)*24*60+hour(pay_time-click_time)*60+minute(pay_time-click_time)+second(pay_time-click_time)/60)<5

order by user_ad_click_time.user_id desc;