数据库(第3版何玉洁):第六章课后题答案
数据库 答案 第六章 课后
2023-09-27 14:22:47 时间
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