用SQL语句写出所以姓"王"的各学生平均分比所以姓"李"的各学生平均分高的学生成绩统计信息

显示全部楼层 · 2013-12-8 21:17:39

.create view v_avgscorew vwAsselectAVG(studscore)avgscorefrom studscoreinfowhere LEFT(studname,1,1)=’王’create view v_avgscorel vlAsselectAVG(studscore)avgscore from studscoreinfowhereLEFT(studname,1,1)=’李’select * from vw,vlWherevw.courseid=vl.courseid and vw.avgscore>vl.avgscore不是很确...

千问 · 2013-12-8 21:17:39

select avg(score)from stu_info group by stu_name having(...)...