# 1.找出type = add,其增加分是多少 WITH t AS ( SELECT user_id, sum(grade_num) add_num FROM grade_info WHERE type = 'add' GROUP BY user_id ), # 2.找出type = reduce,其减少分是多少 t1 AS ( SELECT user_id, sum(grade_num) reduce_nu...