--学校类型数据
SELECT t.examid,'-' AS unitcode,t.schooltype,'-' ASclassname,t.bkrs,t.skrs,t.avgs,SUM(IF(t.avgs<=lt.avgs,lt.avgrank,0))+1-t.avgrank ASavgrank,
t.anum,t.aratio,SUM(IF(t.aratio<=lt.aratio,lt.arrank,0))+1-t.arrank ASarrank,
t.bnum,t.bratio,SUM(IF(t.bratio<=lt.bratio,lt.brrank,0))+1-t.brrank ASbrrank,'2' ASordernumFROM(SELECTschooltypeinfo.examid,schooltypeinfo.objid,schooltypeinfo.testpaperid,schooltypeinfo.wl,schooltypeinfo.subjectid,schooltypeinfo.scoreType,schooltypeinfo.objType,
schooltypeinfo.schooltype,schooltypeinfo.bkrs,schooltypeinfo.skrs,schooltypeinfo.avgs,
schooltypeaa.anum,ROUND(schooltypeaa.anum/schooltypeinfo.skrs,4) aratio
,schooltypebb.bnum,ROUND(schooltypebb.bnum/schooltypeinfo.skrs,4) bratio,COUNT(1)AS avgrank,COUNT(1) AS arrank,COUNT(1) ASbrrankFROM(SELECTdast.examid,dast.objid,dast.testpaperid,dast.wl,dast.subjectid