mysql 链式查询_mysql连接查询

希望能有点帮助，分两段执行。

select b.name 'course_name', a.number 'num_max', a.student_id 'student_id', c.name 'student_name' from score a,course b,student c

where a.number = (select max(number) from score b where a.course_id=b.course_id)

and a.course_id=b.course_id

and a.student_id=c.student_id；

select b.name 'course_name', a.number 'num_min', a.student_id 'student_id', c.name 'student_name' from score a,course b,student c

where a.number = (select min(number) from score b where a.course_id=b.course_id)

and a.course_id=b.course_id

and a.student_id=c.student_id;