题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
https://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
SELECT u.id,u.name,g.grade_num FROM USER u,grade_info g
WHERE u.id NOT IN(SELECT t1.a1 FROM (SELECT user_id a1,SUM(grade_num) n1 FROM grade_info WHERE TYPE='add' GROUP BY user_id)t1
JOIN
(SELECT user_id a2,SUM(grade_num) n2 FROM grade_info WHERE TYPE='reduce' GROUP BY user_id)t2
ON t1.a1=t2.a2 WHERE t1.n1-t2.n2) AND u.id=g.user_id
WHERE u.id NOT IN(SELECT t1.a1 FROM (SELECT user_id a1,SUM(grade_num) n1 FROM grade_info WHERE TYPE='add' GROUP BY user_id)t1
JOIN
(SELECT user_id a2,SUM(grade_num) n2 FROM grade_info WHERE TYPE='reduce' GROUP BY user_id)t2
ON t1.a1=t2.a2 WHERE t1.n1-t2.n2) AND u.id=g.user_id
，大部分部门应该没有吧，我去年实习的部门10 7 5（偶尔甚至六点吃完晚饭就跑）
华为工作强度 1021人发布
投递微众银行等公司10个岗位 >