数据库（第3版何玉洁）：第六章课后题答案

科技前沿 • 2025-03-01 23:39 • 阅读 44

大家好，我是讯享网，很高兴认识大家。

USE 学生管理系统 SELECT * FROM SC SELECT sname,sage FROM student WHERE sdept = '计算机系' SELECT sno,cno,grade FROM SC WHERE grade between 70 and 80 SELECT max(grade)AS 最高分 FROM SC WHERE cno='c01' SELECT max(sage) AS 最大年龄 , min(sage) AS 最小年龄 FROM student WHERE sdept='计算机系' SELECT sdept,COUNT(*) 学生人数 FROM student GROUP BY sdept select sno,count(*)选课门数,sum(grade)考试总成绩 from sc group by sno order by count(*) asc select sno,sum(grade)总成绩 from sc group by sno having sum(grade)>200 select sname,sdept from student join sc on student.sno = sc.sno where cno = 'c02' select student.sno,sname,sdept from student left join sc on student.sno = sc.sno where sc.sno is null select c.cno,count(sc.cno) 选课人数 from course c left join sc on c.cno = sc.cno Group by c.cno select c2.cname,c2.semester from course c1 join course c2 on c1.semester = c2.semester Where c1.cname = 'VB' select S2.Sname,S2.Sdept, S2.sage from student s1 join student s2 on s1.sage = s2.sage Where s1.sname = '李勇’ and s2.sname != '李勇’ select top 2 with ties sname, sage from student Where sdept = '计算机系' Order by sage asc select top 2 with ties sname, sdept, grade from student s join sc on s.sno = sc.sno Join course c on c.cno = sc.cno Where cname = 'VB' Order by grade desc select top 2 with ties sno, count(*) 选课门数 from sc Group by sno Order by count(*) desc select top 1 with ties sdept, count(*) 人数 from student Group by sdept Order by count(*) desc

讯享网

数据库（第3版何玉洁）：第六章课后题答案

相关推荐