Student(Sid,Sname,Sage,Sse*)学生表CREATETABLEstudent(sidvarchar(10)NOTNULL,sNamevarchar(20)DEFAULTNULL,sAgedatetimeDEFAULT'1980-10-1223:12:36',sSe*varchar(10)DEFAULTNULL,PRIMARYKEY(sid))ENGINE=InnoDBDEFAULTCHARSET=utf8;Course(Cid,ame,Tid)课程表CREATETABLEcourse(cidvarchar(10)NOTNULL,amevarchar(10)DEFAULTNULL,tidint(20)DEFAULTNULL,PRIMARYKEY(cid))ENGINE=InnoDBDEFAULTCHARSET=utf8;SC(Sid,Cid,score)成绩表CREATETABLEsc(sidvarchar(10)DEFAULTNULL,cidvarchar(10)DEFAULTNULL,scoreint(10)DEFAULTNULL)ENGINE=InnoDBDEFAULTCHARSET=utf8;Teacher(Tid,Tname)教师表CREATETABLEtaacher(tidint(10)DEFAULTNULL,tNamevarchar(10)DEFAULTNULL)ENGINE=InnoDBDEFAULTCHARSET=utf8;数据：〔MySQL〕insertintotaacher(tid,tName)values(1,教师')，(斓以琛')，(叶平')；insertintostudent(sid,sName,sAge,sSe*)values('11',三丰'，'1980-10-1223:12:36','男')，('12'无极'，'1995-10-1223:12:36','男')，('13'奎'，'1992-10-1223:12:36','女')，('14'元'宝'，'1980-10-1223:12:36',女'),('15','世明','1981-10-1223:12:36','男')，('16六'，'1986-10-1223:12:36','男')，('17田'七'，'1981-10-1223:12:36',女');insertintosc(sid,cid,score)values('1','1',80),('1','2',60),('1','3',75),('2','1',85),('2','2',70),('3','4',1),('3','1',90),('3','2',55),('4','2',65),('4','3',60);insertintocourse(cid,ame,tid)values('1',企业管理'，3),('2马克思'，3),('3','UML',2),('0(数'据库'，1),('5',英语'，1);问题:1、查询"1课程比"2课程成绩高的所有学生的**;selecta.Sidfrom(selectsid,scorefromSCwhereCid='1')a,(selectsid,scorefromSCwhereCid='2')bwherea.score>b.scoreanda.sid=b.sid;2、查询平均成绩大于60分的同学的**和平均成绩；selectSid,avg(score)fromscgroupbySidhavingavg(score)>60;3、查询所有同学的**、、选课数、总成绩;selectStudent.Sid,Student.Sname,count(SC.Cid),sum(score)fromStudentleftOuterjoinSConStudent.Sid=SC.SidgroupbyStudent.Sid,Sname4、查询姓"的教师的个数;selectcount(distinct(Tname))fromTeacherwhereTnamelike'%';5、查询没学过"叶平教师课的同学的**、；selectStudent.Sid,Student.SnamefromStudentwhereSidnotin(selectdistinct(SC.Sid)fromSC,Course,TeacherwhereSC.Cid=Course.CidandTeacher.Tid=Course.TidandTeacher.Tname='叶平');6、查询学过"1并且也学过编号"2课程的同学的**、；selectStudent.Sid,Student.S