select m1.exam_id,; m1.score as 跑,; mi.score as 跳; from 表3 as m1, 表3 as m2; where m1.exam_id = m2.exam_id; and m1.mode = '跑'; and m2.mode = '跳'