题解 | #对试卷得分做min-max归一化#

对试卷得分做min-max归一化

https://www.nowcoder.com/practice/2b7acdc7d1b9435bac377c1dcb3085d6

select uid,exam_id,

round(if(max_score-min_score>0,(avg(score-min_score)/(max_score-min_score)*100),sum(score)),0) as avg_new_score
from
    (select exam_id,
	min(score) as min_score,
	max(score) as max_score
	from exam_record join examination_info
	using(exam_id) where difficulty='hard'
	and score is not null
	group by exam_id) as score_list 
join exam_record using(exam_id)
where score is not null
group by uid,exam_id
order by exam_id,avg_new_score desc

全部评论

相关推荐

那一天的Java_J...:他本来公司就是做这个的,不就是正常的游戏客户端和服务器开发,软硬件联动,有啥恶心不恶心的,提前告诉你就是怕你接受不了,接受不了就没必要再往后走流程浪费时间,虽然这公司是一坨。
点赞 评论 收藏
分享
面向对象的火龙果很爱...:去吃一顿炸鸡就走
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务