美丽的回笼觉觉主在刷代码

分类

/ 注册

全部文章（共7篇）

题解 | #2021年11月每天新用户的次日留存率#

WITH user_t AS ( SELECT uid, DATE_FORMAT(in_time,'%Y-%m-%d') AS timea FROM tb_user_log UNION SELECT uid, DATE_FORMAT(out_time,'%Y-%m-...

2024-08-27

0 146

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

SELECT DISTINCT artical_id, MAX(num_per) OVER (PARTITION BY artical_id) AS max_uv FROM( SELECT *, SUM(count_num) OVER (PARTITION BY artical_i...

2024-08-27

0 170

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

SELECT DISTINCT video_id, ROUND((100*(watch/play_v)+5*like_num+3*comment_num+2*retweet_num)*(1/(DATEDIFF(maxdate,groupmaxdate)+1))) AS hot_index FROM...

2024-08-26

0 143

题解 | #多部门的打工人#

class Nowcoder: def __init__(self, name, ID,num): self.name=name self.ID = ID self.num=num def printinfomation(self): ...

2024-08-24

0 140

题解 | #打工人的统计#

class Nowcoder: def __init__(self,name,ID,num,days=0): self.name=name self.ID=ID self.num=num self.days=days ...

2024-08-24

0 137

题解 | #最长连续登录天数#

主要思路：利用ROW_NUMBER 对每个user_id登录时长进行升序排序，得到date_order列；利用DATE_SUB 将fdate与date_order相减，得到“伪日期列-date2，若连续登录，date2应相同；COUNT计算连续登陆时长取 MAX。 SELECT DISTINCT ...

2024-08-19

82 510

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

SELECT * FROM( SELECT DISTINCT month, ROW_NUMBER() OVER (PARTITION BY month ORDER BY play_pv DESC,song_id)AS ranking, song_name,play_pv FROM ( ...

2024-08-18

0 129