题解 | #输出在5min内完成点击购买的用户ID#
输出在5min内完成点击购买的用户ID
https://www.nowcoder.com/practice/07c74663b484428da99b4769671d2d45
select a.user_id uid from user_ad_click_time a join user_payment_time p on a.trace_id = p.trace_id where TIMESTAMPDIFF(MINUTE,click_time,pay_time) <= 5 order by a.user_id desc
SHEIN希音公司福利 280人发布