oracle数据查询求助！教师信息表Teacher(TID, TName)课程表Course(CID, CName, TID)
发布网友
发布时间：2022-04-10 19:38
共1个回答
热心网友
时间：2022-04-10 21:07
--select CID,AVG(score) from Grade group by CID having AVG(score)>=85 --大于等于85分的课程ID
select a.CNAME,a.TID from Course a
inner join Teacher b on a.TID=b.TID
where a.CID in (select c.CID from Grade c group by CID having AVG(c.score)>=85 ) and b.TName='张三'
