Sql语句:
SELECT s.sid 学号,s.sname 姓名,
MAX(
CASE
WHEN subj.subname = 'chinese'
THEN sc.score
ELSE 0
END
) 语文,
MAX(
CASE
WHEN subj.subname = 'math'
THEN sc.score
ELSE 0
END
) 数学,
MAX(
CASE
WHEN subj.subname = 'english'
THEN sc.score
ELSE 0
END
) 英语
FROM student s INNER JOIN scoreinfo sc ON s.sid = sc.sid INNER JOIN subject subj ON subj.subid = sc.subid GROUP BY s.sid ORDER BY s.sid;