假设表名是students,学生学号是id,四科成绩是score1, score2, score3, score4,用一个嵌套sql可以实现:
select sum(p1), sum(p2), sum(p3), sum(p4) from (select last(score1) > last(prev(score1)) as p1, last(score2) > last(prev(score2)) as p2, last(score3) > last(prev(score3)) as p3, last(score4) > last(prev(score4)) as p4 from students group by id)