单选题小明、小王、小李，分别是教育学、化学、数学专业的学生。现在知道：小李比数学专业的年龄大，小明和化学专业的不同岁，化学专业的比小王年龄小。 由此，可以推断出（）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: 分数

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