检索出每个班级中分数最低的同学id，姓名，分数，班级名称

Question

tb_student表：
id name
30 d3
49 c3
51 a3
52 b3
tb_score表：
stu_id score
30 99
49 79
51 80
52 59
tb_class表：
id name
1 class-1
2 class-2
3 class-1
4 class-2
tb_student_class表
id stu_id class_id
1 30 1
2 49 2
3 51 1
4 52 2
输出
stu_id stu_name class_name score
51 a3 class-1 80
52 b3 class-2 59

Answer 1

select s.stu_id, stu.name as stu_name, cs.class_name, cs.score from 
(select c.name as class_name, min(s.score) as score from tb_student_class sc left join tb_score s on sc.stu_id = s.stu_id left join tb_class c on sc.class_id = c.id group by c.name) cs 
left join tb_score s on cs.score = s.score left join tb_student stu on s.stu_id = stu.id