不精独乐乐

分类

/ 注册

全部文章（共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