ent(3)selects_no,s_name,s_birthdayfromStudentwheres_sex='男'(4)Selects_no,s_name,s_sex,s_birthdayFromStudentWhere(s_sex='女')and(s_birthday<='1980-01-01')(5)selects_no,s_name,s_sex,s_birthdayfromStudentWheres_sex='男'ands_namelike'李%'(6)selects_no,s_nameFromstudentWheres_namelike'%一%'(7)selectt_no,t_name,t_titlefromTeacherwheret_titlenotin('讲师')(8)selects_nofromChoicewherescoreisnull(9)selects_no,scorefromChoicewherescore<60orderbyscoredesc(10)selectcourse_no,course_namefromCoursewherecourse_noin('01001','02001','02003')(11)selectt_no,t_name,t_birthdayfromTeacherwheret_birthdaybetween'1970-1-1'and'1970-12-12'(12)selectcourse_no,count(*)人数fromChoicegroupbycourse_no;(13)select*from(selectt_no,count(*).c>=2(14)selectavg(score)as平均成绩,max(score)as最高分,min(score)as最低分fromChoicewherecourse_no='01001'
全文预览
