学生成绩查询

【MySQL】查询学⽣成绩，并作详细分级：

【MySQL】查询学⽣成绩，并作详细分级:

ca...end语句做嵌套

#创建学⽣成绩

#创建学⽣成绩

createdatabatest;

utest;

createtablecour

(

Student_idchar(12)notnullcomment"学号",

Cour_idchar(4)notnullcomment"课程号",

scoreintdefault0comment"成绩"

);

inrtintocourvalues

("2","1001",65),

("2","1001",76),

("2","1001",87),

("2","1001",69),

("2","1001",96),

("2","1001",82),

("2","1001",72),

("2","1001",64);

lect

Student_idas学号,

Cour_idas课程编号,

(cawhenscore>=90then"优秀"

el

(cawhenscore>=80then"良好"

el

(cawhenscore>=70then"中等"

el

(cawhenscore>=60then"及格"el"不及格"end)

end)

end)

end)as成绩情况

fromcour;