📄 新建 文本文档 (3).txt
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -