DQ_restart

分类

题解(24)

/ 注册

全部文章（共46篇）

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

with t1 as ( select a.video_id, date_format(a.start_time,'%Y-%m-%d') start_time, date_format(a.end_time,'%Y-%m-%d') end_time, da...

2023-02-15

0 346

题解 | #国庆期间每类视频点赞量和转发量#

with t1 as ( select a.video_id, date_format(a.start_time,'%Y-%m-%d') start_time, a.if_like, a.if_retweet, b.tag from tb_user_video_log a join ...

2023-02-15

0 331

题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#

with t1 as ( select a.uid, a.video_id, a.if_follow, b.author, date_format(a.start_time,'%Y-%m-01') start_time from tb_user_video_log a join t...

2023-02-15

0 344

题解 | #每类视频近一个月的转发量/率#

with t1 as ( select vl.video_id, vi.tag, vl.if_retweet, date_format(vl.start_time,'%Y-%m-%d') start_time, max( date_format(vl.end_...

2023-02-13

0 373

题解 | #平均播放进度大于60%的视频类别#

with t1 as ( select unix_timestamp(vl.end_time) - unix_timestamp(vl.start_time) ts, vi.tag, vi.duration from tb_user_video_l...

2023-02-13

0 294

题解 | #各个视频的平均完播率#

with t1 as ( select vl.uid, vl.video_id, unix_timestamp(vl.start_time) start_time, unix_timestamp(vl.end_time) end_time, vi.duration from tb_u...

2023-02-13

0 312

题解 | #月总刷题数和日均刷题数#

我就要搞不一样的 with t1 as ( select '01' month, 31 days from dual &n...

2022-08-26

0 345

题解 | #平均活跃天数和月活人数#

with t1 as ( SELECT uid, DATE_FORMAT(submit_time,'%Y%m%d') month FROM exam_record WHERE score is&nb...

2022-08-26

0 353

题解 | #得分不小于平均分的最低分#

我认为我在这道解题的方法用到的绝妙用处是1 flag WITH t1 AS ( SELECT exam_id, score, 1 flag FROM exam_record WHERE exam_id&nb...

2022-08-25

0 352

题解 | #筛选某店铺最有价值用户中消费最多前5名#

2022.8.16 提交完最后一道Pandas数据分析，有机会重头再做一遍 import pandas as pd import numpy as np sales = pd.read_csv("sal...

Python3

2022-08-16

3 451