sql分组求和语句求图中题的语句

Question

请问这个语句要怎么写才能实现？select Subject，
sum(case Subject when 'Language' then Passman else 0 end) Grade1,
sum(case Subject when 'Mathematics' then Passman else 0 end)Grade2,
sum(case Subject when 'English' then Passman else 0 end) Grade3,
Grade1+Grade2+Grade3 as TotalPassMan
from TestTable group by Subject
这样对吗？

Answer 1

select Subject
sum(case Subject when 'Language' then Passman else 0 end) Grade1,
sum(case Subject when 'Mathematics' then Passman else 0 end)Grade2,
sum(case Subject when 'English' then Passman else 0 end) Grade3,
Grade1+Grade2+Grade3 as TotalPassMan
from TestTable group by Subject
大佬们这样对吗？