牛客283607898号

分类

/ 注册

全部文章（共13篇）

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

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) &l...

2024-09-08

0 71

题解 | #广告点击的高峰期#

select hour(click_time) as click_hour, count(click_time) as click_cnt from user_ad_click_time group by hour(click_time) order by count(cl...

2024-09-08

0 99

题解 | #查询用户刷题日期和下一次刷题日期#

select user_id,date,lead(date,1)over(partition by user_id order by date) nextdate from questions_pass_record order by user_id, date

2024-09-08

0 71