若用Student表存储学生信息,Teacher表存储教师信息,Course表存储课程信息,Study表存储学生选修课
SELECT *FROM Student WHERE Smajor="CS" AND Syear="2006"
AND(1))
(SELECT Sno FROM Study GROUP BY Sno
HAVING(2))
SELECT *FROM Student WHERE Smajor="CS" AND Syear="2006"
AND(1))
(SELECT Sno FROM Study GROUP BY Sno
HAVING(2))
若另有表Teach(CName,TName)存储教师任课情况,Tname表示教师名。用SQL创建一个含有学号、姓名、课程名、成绩、任课教师名的“主修专业为计算机CS”的学生成绩视图,并要求进行修改、插入操作时保证该视图只有计算机系的学生。请在SQL语句空缺处填入正确的内容。
CREATE VIEW SG (1)
SELECT Student.SNo,SName,Grade,Course.CName,TName
FROM Student,Grade,Teach,
WHERE (2)
AND (3)
AND Major='cs',
(4);
(1)
已知学生-课程数据库 § Student (Sno, Sname, Ssex, Sage, Sdept) § Course (Cno, Cname, Cpno, Ccredit) § SC (Sno, Cno, Score) (1)创建一个存储过程并执行之:用输出参数返回指定学生的所有课程的成绩的平均值。 (2)创建一个after触发器,要求更新学生表Student中学号时,成绩表SC中的学号发生相应变化。
A.select * from student order by age
B.select * from student group by age
C.select * from student order by age desc
D.select * from student group by age desc
A.Select*Fromstudentwherecode=1001
B.Select*Fromstudentwherecode=1001
C.Select*Fromstudentwherecode=1001
D.Select*Fromstudentwherecode=1001
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!