2-14.sql

来自「一个数据库的选课系统」· SQL 代码 · 共 4 行

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