【2022.4.6】数据库系统概念第六版第三章

---

一、题目

二、3.11

a.

select distinct name
from takes,student,course
where takes.ID=student.ID and takes.course_id=course.course_id and course.dept_name='Comp. Sci.'

b.

select distinct(student.ID),name
from takes,student
where not exists
(select *
from takes,student
where takes.ID=student.ID and  takes.year<2009)

---

c.

select dept_name,max(salary)
from instructor
group by dept_name

d.

with tmp as (select dept_name,max(salary) as s
from instructor
group by dept_name)
select min(s) as minus
from tmp

总结

作业又不收了 老师我爱你