fromChoicegroupbycourse_no;(13)select*from(selectt_no,count(*).c>=2(14)selectavg(score)as平均成绩,max(score)as最高分,min(score)as最低分fromChoicewherecourse_no='01001'(15)selectt_name,t_birthdayfromTeacherwhere(t_birthday>1960)and(t_title='讲师')orderbyt_birthdaydesc3.复杂的数据查询(1)selectstudent.s_no,s_name,course_no,scorefromStudentleftouterjoinChoiceonStudent.s_no=Choice.s_no(2)selects_name,Course.course_name,scoreintonew_tablefromStudent,Choice,CoursewhereCourse.course_no=Choice.course_noandStudent.s_no=Choice.s_no(3)selectStudent.s_no,s_name,Choice.course_no,course_name,scorefromclass,Student,Choice,Coursewhereclass_name='计算机99-1'andChoice.course_no=Course.course_noandChoice.s_no=Student.s_no(4)selectStudent.s_no,s_name,sum(course_score)astotal_scoreFromStudentInnerjoinChoiceonStudent.s_no=Choice.s_no
全文预览
