SQL数据库多表链接 问题
发布网友
发布时间：2022-04-11 23:52
共1个回答
热心网友
时间：2022-04-12 01:21
select s.Sno as 学号, s.Sname as 姓名, d.Dname aS 所在系
from Student as s inner join Dept as d
on s.Dno = d.Dno
2.
select avg(Grade)
from SC as sc inner join Student as s
on sc.Sno = s.Sno
inner join Dept as d
on s.Dno = d.Dno
where d.Dname = '计算机'
........
