Student:
Score
1.查询年龄超过20岁的姓名\年龄\所在班级
select
sName,
sAge,
cName
from Student as TS
inner join Class TC
on TC.clsId=TS.sClassId
where sAge>20
------------------------------------------------------------------------------------------------------------------------
2.查询出所有参加考试的同学的学生编号,姓名,考试成绩。
select