wanwans
wanwans
全部文章
题解
未归档(2)
归档
标签
去牛客网
登录
/
注册
wanwans的博客
全部文章
/ 题解
(共14篇)
题解 | #连续签到领金币#
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
216
题解 | #某乎问答最大连续回答问题天数大于等于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
201
题解 | #国庆期间每类视频点赞量和转发量#
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
211
题解 | #国庆期间每类视频点赞量和转发量#
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
311
题解 | #浙大不同难度题目的正确率#
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
160
题解 | #创建一个actor_name表#
select a.user_id, min(a.date) as first_buy_date, max(a.date) as second_buy_date, a.cntfrom (select user_id, date, rank() over(partition...
2021-08-09
0
256
题解 | #创建一个actor_name表#
select job,strftime('%Y-%m',date) as mon,sum(num) as cnt from resume_infowhere date >'2025-01-01' and date <'2025-12-31'group by job,mono...
2021-08-09
0
302
题解 | #创建一个actor_name表#
select t.user_idfrom(select user_idfrom order_infowhere date>'2025-10-15'and status='completed'and product_name in ('C++','Java','Python')) tgroup ...
2021-08-09
0
289
题解 | #创建一个actor_name表#
select a.id,a.job,a.scorefrom grade a join(select job,round(avg(score),3) avgfrom gradegroup by job) ton a.job=t.job and a.score>t.avgorder by a.id...
2021-08-09
0
272
题解 | #创建一个actor_name表#
selecte.emp_no,e.first_name,e.last_name,b.btype,s.salary,s.salaryb.btype0.1 as bonusfromemployees e,emp_bonus b,salaries swheres.to_date='9999-01-01'a...
2021-08-08
0
290
首页
上一页
1
2
下一页
末页