（建表陳述句和表內容和我的代碼都復制過來了）
如題，運行結果測驗了和輸出樣例一致，但是測驗點一直過不了顯示答案錯誤，煩請大佬們看看是哪點有問題？
題目
檢索出每個班級中分數最低的同學id，姓名，分數，班級名稱
表結構:
create table tb_student (
id int not null primary key,
name varchar(32)
);
create table tb_score (
stu_id int,
score int
);
create table tb_class (
id int not null,
name varchar(32)
);
create table tb_student_class
(
id int null,
class_id int null,
stu_id int null
);
表樣例
tb_student表：
id name
30 ddd
49 ccc
51 aaa
52 bbb
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 aaa class-1 80
52 bbb class-2 59
我的代碼
select
s.id as stu_id,
s.name as stu_name,
c.name as class_name,
sc.score as score
from tb_student as s
inner join tb_student_class as tc
on s.id=tc.stu_id
inner join tb_class as c
on c.id=tc.class_id
inner join tb_score as sc
on sc.stu_id=s.id
and score = (
select min(e.score)
from tb_score as e,tb_class as f,tb_student_class as g
where c.name=f.name and f.id=g.id and e.stu_id in(
select stu_id
from tb_student_class as h
where h.class_id = g.class_id
)
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/272677.html
標籤：MySQL
上一篇：PB9與JAVA WEB程式介面，報STATUS 500錯誤
下一篇：單機redis如何保證高可用性