SELECTCASE WHEN B.SUBJECT='语文' THEN B.SCORE ELSE 0 END AS 语文,CASE WHEN B.SUBJECT='数学' THEN B.SCORE ELSE 0 END AS 数学FROM SCORE B两个括号取了
