会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

题解 | 实习广场投递简历分析(三)

with a as (select job, date_format(date,'%Y-%m') as first_year_mon, sum(num) as first_year_cnt from resume_info where year(date)=2025 group by jo...

2025-06-16

0 18

题解 | 统计用户从访问到下单的转化率

with a as (select date_format(order_time,'%Y-%m-%d') as date,count(distinct user_id) as cnt1 from order_tb group by date_format(order_time,'%Y-%m-%d'...

2025-06-16

0 25

题解 | 被重复观看次数最多的3个视频

select b.cid,pv, row_number() over(order by pv desc,release_date desc) as rk from (select cid,sum(pv) as pv from (select cid,uid, round(cast(count...

2025-06-09

0 25

题解 | 店铺901国庆期间的7日动销率和滞销率

with a as (select distinct date(event_time) as dt from tb_order_overall where date(event_time) between '2021-10-01' and '2021-10-03'), b as (select ...

2025-06-08

0 27

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

select * from (select tag,date_format(start_time,'%Y-%m-%d') as dt, sum(sum(if_like)) over (partition by tag order by date_format(start_time,'%Y-%m-%...

2025-06-07

0 20

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

select video_id, cast((100*wanbo+5*dianzan+3*pinglun+2*zhuanfa)*xinxian as signed)as hot_index from (select t1.video_id, count(case when (timestampdif...

2025-06-06

0 22

题解 | 0级用户高难度试卷的平均用时和平均得分

select uid, cast(avg(score_took) as signed) as avg_score, round(avg(time_took),1) as avg_time_took from (select ui.uid,er.exam_id, ifnull(timestampdi...

2025-06-05

0 18

题解 | 统计有未完成状态的试卷的未完成数和未完成率

with a as (select distinct exam_id from exam_record where submit_time is null) select exam_id, count(case when submit_time is null then 1 else null e...

2025-06-02

0 19

题解 | 每份试卷每月作答数和截止当月的作答总数。

select *,sum(month_cnt) over (partition by exam_id order by start_month) as cum_exam_cnt from (select distinct exam_id,date_format(start_time,'%Y%m') ...

2025-06-02

0 24

题解 | 对试卷得分做min-max归一化

with a as (select er.exam_id,max(score) as da, min(score) as xiao from examination_info ei join exam_record er on ei.exam_id = er.exam_id where diffic...

2025-06-01

0 16