数据库笔记6

查询每条成绩对应的学生号，课程名，分数

select coursename,studentid,grade

from course,grade

where grade.CourseID=course.CourseID

内连接

select studentid,coursename,grade

from grade inner join course on grade.CourseID=course.CourseID

查询每条成绩对应的学生名，课程号，分数

select studentname,courseid,grade

from student,grade

where grade.StudentID=student.StudentID

保留没有选课的同学的信息

select studentname,courseid,grade

from grade right join student on grade.StudentID=student.StudentID

求每门课程的平均分，输出课程名字和平均分

select coursename,grade

from course,grade

where grade.CourseID=course.CourseID

group by coursename

查询选