题解 | 输出在5min内完成点击购买的用户ID
select
uact.user_id uid
from
test.user_ad_click_time uact
join test.user_payment_time upt on uact.user_id = upt.user_id
and uact.trace_id = upt.trace_id
where
timestampdiff (minute, click_time, pay_time) < 5
汤臣倍健公司氛围 434人发布