KoolHero

分类

/ 注册

全部文章（共4篇）

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

select t1.user_id as uid from user_ad_click_time t1 left join user_payment_time t2 on t1.user_id = t2.user_id and t1.trace_id = t2.trace_id where ...

2024-08-27

0 100

题解 | #每篇文章同一时刻最大在看人数#

select artical_id , max(uv) as max_uv from ( select artical_id , time , sum(df) over(order by time asc, df desc) as uv fro...

2024-08-18

0 109

题解 | #近一个月发布的视频中热度最高的top3视频#

select video_id , round((100 * rates + 5*likes + 3*comments + 2*retweets) / (no_play+1), 0) as hot_index from ( select t1.video_id ...

2024-08-18

1 96

题解 | #每个月Top3的周杰伦歌曲#

with tmp as ( select month(t1.fdate) as month , row_number() over(partition by month(t1.fdate) order by count(t1.song_id) desc, t1.song_i...

2024-08-11

5 180