1.txt

来自「一个数据库SQL语言」· 文本 代码 · 共 10 行

select distinct student   
from   enrolls,teachers,sections   
where  exists   
      (select *   
       from enrolls,teachers,sections   
       where teachers.teacher=sections.teacher and sections.course=enrolls.course and teachers.teachername='Dr.Lowe'   
       group by student   
       having count(distinct enrolls.course)=(select count(distinct enrolls.course)   
                                   from enrolls,teachers,sections   
                                   where teachers.teacher=sections.teacher and sections.course=enrolls.course and teachers.teachername='Dr.Lowe')