(方式一)SELECTsc.cidAS"课程ID",c.cnameAS"课程名",AVG(sc.score)AS"平均成绩",SUM(CASEWHENsc.score>60THEN1ELSE0END)/COUNT(1)*100AS"及格百分数"FROMsc sc, course cWHEREsc.cid=c.cidGROUPBYsc.cidORDERBYAVG(sc.score)ASC,SUM(CASEWHENsc.score>60THEN1ELSE0END)/COUNT(1)*100DESC(方式二)SE...
1、表架构 student(sid,sname,sage,ssex) 学生表 course(cid,cname,tid) 课程表 sC(sid,cid,score) 成绩表 teacher(tid,tname) 教师表 2、建表sql语句 SETFOREIGN_KEY_CHECKS=0;---Table structure for course---DROPTABLEIFEXISTS`course`;CREATETABLE`course` ( `cid`int(11)NOTNULL, `cname`varchar...