不精独乐乐
不精独乐乐
全部文章
分类
归档
标签
去牛客网
登录
/
注册
不精独乐乐的博客
全部文章
(共156篇)
题解 | #月均完成试卷数不小于3的用户爱作答的类别#
select tag, count(tag) a from exam_record left join examination_info using(exam_id) where uid in( select uid from exam_record where date_format(submit...
2023-03-05
0
131
题解 | #发送offer#
offer_list=[ 'Allen' , 'Tom' ] for i in offer_list: print('{}, you have passed our interview and will soon become a member of our company.'.format...
2023-03-04
0
151
题解 | #未完成试卷数大于1的有效用户#
select uid, count(if(submit_time is null,1,null)) a, count(submit_time) b, group_concat(distinct concat_ws(':',date(start_time),tag) separator ';') f...
2023-03-04
0
165
题解 | #月总刷题数和日均刷题数#
select ifnull(a,'2021汇总'), month_q_cnt, avg_day_q_cnt from( select date_format(submit_time,'%Y%m') a, count(score) month_q_cnt, round(count(score)/M...
2023-03-04
0
199
题解 | #SQL类别高难度试卷得分的截断平均值#
select tag, difficulty, round(avg(score),1) from( select tag, difficulty, score, row_number()over(order by score) a, row_number()over(order by score ...
2023-03-04
0
198
题解 | #浙大不同难度题目的正确率#
select difficult_level, count(if(result='right',1,null))/count(result) correct_rate from question_practice_detail a left join question_detail b using(...
2023-03-02
0
168
题解 | #统计复旦用户8月练题情况#
select tb1.device_id, university, count(date), count(if(result='right',1,null)) from user_profile tb1 left join question_practice_detail tb2 using(dev...
2023-03-02
0
113
题解 | #网易云音乐推荐(网易校招笔试真题)#
思路:①找出user_id=1的人关注者的音乐id,音乐名,形成tb2;②在tb2里剔除user_id=1已经有的音乐即可。 with tb2 as( select music_id, music_name from music_likes left join music on music...
2023-02-28
0
277
题解 | #商品交易(网易校招笔试真题)#
select goods.id, name, weight, sum(count) total from trans left join goods on trans.goods_id=goods.id where weight<50 group by goods.id, name, weig...
2023-02-28
0
207
题解 | #获得积分最多的人(三)#
select id, name, sum_g from( select id, name, sum_g, rank()over(order by sum_g desc) as r from( select id, name, sum(diff) as sum_g from( select id, n...
2023-02-27
0
147
首页
上一页
5
6
7
8
9
10
11
12
13
14
下一页
末页