新建 文本文档 (3).txt

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

select distinct coursename,studentname,teachername,grade   
from students,courses,enrolls,sections,teachers   
where courses.course=sections.course and sections.course=enrolls.course and students.student=enrolls.student and teachers.teacher=sections.teacher and students.student=enrolls.student   
group by enrolls.student,courses.coursename,students.studentname,teachers.teachername,enrolls.grade  

select distinct coursename,studentname,teachername,grade 
from students,courses,enrolls,sections,teachers 
where courses.course=sections.course and sections.course=enrolls.course and students.student=enrolls.student and teachers.teacher=sections.teacher and students.student=enrolls.student 
group by enrolls.student,courses.coursename,students.studentname,teachers.teachername,enrolls.grade