SELECT
name '姓名',
SUM(
CASE course
WHEN '语文' THEN
score
ELSE
0
END
) '语文',
SUM(
CASE course
WHEN '数学' THEN
score
ELSE
0
END
) '数学',
SUM(
CASE course
WHEN '物理' THEN
score
ELSE
0
END
) '物理'
FROM
`tablea`
GROUP BY
`name`
//必须要用SUM()