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

SELECT uact.user_id AS uid
FROM user_ad_click_time uact
INNER JOIN user_payment_time upt ON uact.trace_id = upt.trace_id
WHERE TIMESTAMPDIFF(MINUTE, click_time, pay_time) <= 5
ORDER BY uid DESC;