MySQL里面1.如何查询莫一年莫个月份的学生学号和分数

1.SELECTstudentNo学号,studentResult成绩FROMresultWHEREexamDate='2016-02-17'ORDERBYstudentResultDESCLIMIT5;2.SELECTsstudentname姓名,YEAR(NOW())-YEAR(bornDate)年龄,出生日期生日,电话手机号码FromstudentWHEREsex='女'按出生日期排序ASCLIMIT1,6;3.SELECTYEAR(birthdate)年份,COUNT(YEAR(birthdate))学生人数FROMstudentGROUPCITYYEAR(birthdate)HAVINGCOUNT(YEAR(birthdate))>=24.SELECTMAX(studentResult)最大值,MIN(studentResult)最小值,AVG(studentResult)平均值FROMresultWHEREexamDate='2016-02-17'

mysql查询平均成绩

查找每个科目的最高和最低分数selectobject_noas'课程编号',max(score)as'最高分数',min(score)as'最低分数'fromscoregroupbyobject_no1询问所选学生的每门课程编号ofStudentsselectobject_noas'课程号',count(DISTINCTstudents_no)as's'学生号'fromscoregroupbyobject_no1求出选择性别'性别'的男生和女生的数量,count(DISTINCTstudents_no)'number'fromstudentsgroupbysex1求出没有学生选择学号号的平均分',avg(score)as'平均分'fromscoregroupbystudents_no1请求学生ID和学生平均分,平均分大于70分selectstudents_noas'学生人数',avg(score)as'averagescore'fromscoregroupbystudents_noHAVINGavg(score)>701查询参加考试的学生人数selectstudents_noas'学生人数',count(object_no)as'课程编号'fromscoregroupbystudents_no1问题参加两门以上课程考试的学生人数selectStudents_noas'学号',count(object_no)as'课程号'fromscoregroupbystudents_noHAVINGcount(object_no)>21搜索学生列表同名并统计同名学生人数selectstudents_nameas'学生名',count(students_name)as'同名学生人数name'fromstudentsgroupbystudents_nameHAVINGcount(students_name)>11计算每门课程的平均分selectobject_noas'课程号',avg(score)as'平均分'fromscoregroupbyobject_no1计算各科平均成绩GPA且GPA大于等于70分所选的ject_noas'课程number',avg(score)as'平均分'fromscoregroupbyobject_noHAVINGavg(score)>701查找不及格课程并按课程号从高到低排序selectobject_noas'课程号',students_no'学号',result'result'fromresultResult1搜索每门课程的平均分。
coursenumber',avg(score)as'averagesscore'fromscoregroupbyobject_noorderbyavg(score)desc,object_noasc1