会编程的发呆爱好者加麻加辣
会编程的发呆爱好者加麻加辣
全部文章
分类
归档
标签
去牛客网
登录
/
注册
会编程的发呆爱好者加麻加辣的博客
全部文章
(共208篇)
题解 | 店铺901国庆期间的7日动销率和滞销率
with date_check as (select distinct date(event_time) as dt from tb_order_overall where date(event_time) between '20211001' and '20211003' ), b as (sel...
2025-07-05
0
12
题解 | 国庆期间每类视频点赞量和转发量
with basic as (select distinct tag,t.video_id,date(start_time) as dt from tb_user_video_log t join tb_video_info ti on t.video_id = ti.video_id where ...
2025-07-05
0
11
题解 | 近一个月发布的视频中热度最高的top3视频
with cur_date as (select max(date(end_time)) as cur from tb_user_video_log), #近一个月发布的视频 video_release as (select distinct ti.video_id from tb_video_...
2025-07-04
0
11
题解 | 各城市最大同时等车人数
with basic as (select * from(select uid,city,event_time as dt,1 as flag from tb_get_car_record union select tr.uid,city,ifnull(start_time,finish_ti...
2025-07-03
0
11
题解 | 每篇文章同一时刻最大在看人数
with a as (select uid,artical_id, in_time as dt,1 as flag from tb_user_log where artical_id!=0 union select uid,artical_id, out_time as dt,-1 as flag...
2025-07-03
0
11
题解 | 统计活跃间隔对用户分级结果
with hebing as (select uid,artical_id,date(in_time) as date from tb_user_log union select uid,artical_id,date(out_time) as date from tb_user_log), cu...
2025-07-02
0
18
题解 | 每类试卷得分前3名
#每个用户在每个试卷下的最大分和最小分 with a as (select tag,uid,max(score) as max_score,min(score) as min_score from examination_info ei join exam_record er on ei.exam_...
2025-06-26
0
12
题解 | 连续签到领金币
#每天金币数 select uid,date_format(d,'%Y%m') as month,sum(day_coin) as coin from (select uid,d, (case when count(primary_date) over(partition by uid,primar...
2025-06-26
0
16
题解 | 有取消订单记录的司机平均评分
#目标司机 with a as (select distinct driver_id from tb_get_car_order where mileage is null and date_format(order_time,'%Y%m')='202110') select ifnull(dri...
2025-06-23
0
22
题解 | 根据指定记录是否存在输出不同情况
with a as (select u.uid,count(case when submit_time is null and start_time is not null then 1 else null end) as cnt from user_info u left join exam_r...
2025-06-22
0
15
首页
上一页
1
2
3
4
5
6
7
8
9
10
下一页
末页