按照先后顺序依次显示学生表的最大、最小和平均年龄,对应的SQL语句是()。得分/总分A.SelectMAX(Sage),MIN(Sage),AVG(Sage)fromStudentB.SelectMAX,MIN,AVGSagefromStudentC.SelectMIN,MAX,AVGSagefromStudentD.SelectMIN(Sage),MAX(Sage),AVG(Sage)fromStudent
A
将SC和Student表连接起来,显示学生的学号、姓名、课程号、考试分数,不正确的SQL语句是()。得分/总分A.SelectStudent.Sno,Student.Sname,SC.Cno,SC.GradeFromSCJoinStudentOnSC.Sno=Student.SnoB.SelectStudent.Sno,Student.Sname,SC.Cno,SC.GradeFromSC,StudentWhereSC.Sno=Student.SnoC.SelectStudent.Sno,Student.Sname,SC.Cno,SC.GradeFromSC,StudentOnSC.Sno=Student.SnoD.SelectStudent.Sno,Student.Sname,SC.Cno,SC.GradeFromStudentJoinSCOnSC.Sno=Student.Sno
C