select Name,
sum(case when Subject='语文' then Result end) as '语文',
sum(case when Subject='数学' then Result end) as '数学',
sum(case when Subject='物理' then Result end) as '物理',
sum(case when Subject='英语' then Result end) as '英语'
from student group by Name