随便写写, 仅供参考:select cl.className, co.course, avg(sc.score)
from student st
inner join score sc on sc.stuID = st.stuID
inner join class cl on c.classID = st.classID
inner join course co on co.courseID = sc.courseID
group by cl.className, co.course
java吧 关注：1,242,640贴子：12,717,052
- 2回复贴，共1页
随便写写, 仅供参考:select cl.className, co.course, avg(sc.score)
from student st
inner join score sc on sc.stuID = st.stuID
inner join class cl on c.classID = st.classID
inner join course co on co.courseID = sc.courseID
group by cl.className, co.course
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1林孝埈短道速滑500米夺金2070510
- 2梁靖崑掀翻王楚钦晋级决赛1846691
- 3林孝埈为何总在决赛中表现失误1423240
- 4外媒称哪吒2票房高但没人关注1418607
- 5哪吒是天津人还是四川人1135472
- 6林诗栋梁靖崑会师决赛1067025
- 7小行星撞击地球概率大吗747312
- 8Gumayusi不打比赛转行卖课609684
- 9曝拳头正开发类原神游戏437140
- 10NIP横扫FPX取两连胜379701
