关怀老师曾经在偃师一所中学任教哪一科目：（）。A、自然法学B、英语C、数学D、语文

select a.名字, b.km_s, c.km_y, d.km_y, e.km_h, f.km_w from 表 as a join (select 分数,名字 from 表 where 科目='数学') as b on a.名字=b.名字 join(select 分数,名字 from 表 where 科目='语文') as c on a.名字=c.名字 join(select 分数,名字 from 表 where 科目='英语') as d on a.名字=d.名字 join(select 分数,名字 from 表 where 科目='化学') as e on a.名字=e.名字 join(select 分数,名字 from 表 where 科目='物理') as f on a.名字=f.名字
如果有的人某些科目没考，不一定都考这5科， 有的只考2科：

select a.id, a.n, b.km_s, c.km_y, d.km_y, e.km_h, f.km_w from (select id, n from tt group by n) as a left join (select s as km_s,n from tt where k='数学') as b on a.n=b.n left join (select s as km_y,n from tt where k='语文') as c on a.n=c.n left join (select s as km_y,n from tt where k='英语') as d on a.n=d.n left join (select s as km_h,n from tt where k='化学') as e on a.n=e.n left join (select s as km_w,n from tt where k='物理') as f on a.n=f.n order by a.id;tt: 表名n: 名字k: 科目s: 分数

希望能帮到你，别忘了采纳我的答案哦，祝你生活愉快！