sql查询多表

子查询（无关子查询和相关子查询）

use student_data
select *from S
select *from C
select *from SC
/*（3）嵌套查询*/
/*①查询选修了“JAVA”课程的学生的学号和姓名。*/
select sno,sname
from S
where sno in
(
select sno from SC
where cno in
(
select cno from C
 where cname='Java'
 )
 )
elect C.Cno,C.Cname,AVG(SC.Grade*1.0) '平均数'
 from C join SC
 on C.Cno=SC.Cno
 group by C.Cno,C.Cname

select C.Cname,S.* ,SC.Cno,C.Cno 
from S join (C join SC on C.Cno=SC.Cno)
on S.Sno=SC.Sno and C.Cname like '计算机%'