MySQL开发心得笔记超详细及SQL语法考核(4)

mysql> select s.name 姓名,s.code 学号,e.subject 学科,e.score 成绩
    -> from student s
    -> join exam e
    ->    on s.code=e.code
    -> where (e.subject,e.score) in
    -> (
    ->  select subject,max(score)
    ->  from exam
    ->  group by subject
    -> );

7）列出每位学生的各科成绩，要求输出格式：姓名、学号、语文成绩、数学成绩、英语成绩，SQL怎么编写？