wanwans
wanwans
全部文章
分类
未归档(2)
题解(17)
归档
标签
去牛客网
登录
/
注册
wanwans的博客
全部文章
(共5篇)
题解 | #连续签到领金币#
select uid, date_format(dt,'%Y%m') as month, sum(day_coin) as coin from (select uid,dt, case (rk1%7) when 3 then 3 whe...
Mysql
2022-05-17
0
225
题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#
select t2.author_id, t3.author_level, t2.days_cnt from (select author_id,count(1) as days_cnt from (select distinct answer_date, author_id, dense_rank...
Mysql
2022-05-17
0
204
题解 | #国庆期间每类视频点赞量和转发量#
SELECT uid, DATE_FORMAT(dt,'%Y%m') month, sum(day_coin) coin from (SELECT *, DATE_SUB(dt,INTERVAL rn day) dt_tmp, case DENSE_RANK() over(PARTITION BY ...
Mysql
2022-05-07
0
212
题解 | #国庆期间每类视频点赞量和转发量#
select * from (select tag ,dt ,sum(like_d)over(partition by tag order by dt rows between 6 preceding and current row) as sum_like_cnt_7d ,max(retweet_...
Mysql
2022-04-13
0
312
题解 | #浙大不同难度题目的正确率#
select d.difficult_level, sum(if(q.result='right',1,0))/count(q.question_id) as correct_rate from question_practice_detail q inner join user_profile ...
Mysql
2022-03-31
0
164