insert into yzjh(orgno,gno,regc,regd,cttp,orgnm,sctyp,bjs,dbe,bys,zss,zxss,ggjs,zrjs,tyjs,ysjs,dbjs,jxjfyf,ydcdmj,dmtjs,jxyq,zyjsqt)select jc1.organization_no,jc1.gather_organization_no,jc1.regionC,jc1.regionD,jc1.city_country_type,jc1.organization_name,jc1.school_running_type,jc1.c as'班级数',jc1a.c1 as'50人以上班级数',jc2.c as'毕业生数',jc2.d as'招生数',jc2.e as'在校生数',jc0.d as'县级骨干教师',jc3.c as'专任教师',jc3.s as'体育与健康教师',jc3.t as'艺术教师',jc4.c1 as'专科以上教师',jc5.f as'教学及辅助用房',jc6.d as'运动场地面积',jc7.d as'网络多媒体教室',jc8.d as'教学仪器设备值',jc51.c as'专用教室中其他面积(含音美教室)'
from "教基1102续"jc0,"教基2107"jc1,(select organization_no,organization_name,sum(c)as c1 from"教基2107" where b in(8,9,10,11) GROUP BY organization_no)jc1a,"教基3115"jc2,"教基4155"jc3,(select organization_no,organization_name,sum(c)as c1 from "教基4155" where b in(14,15,16) GROUP BY organization_no)jc4,"教基5170"jc5,(select*from"教基5170" where b=9)jc51,(select*from"教基5176" where c=3)jc6,(select*from"教基5176" where c=13)jc7,(select*from"教基5176" where c=15)jc8
where jc1.b=1 and jc1.organization_no=jc2.organization_no and jc2.b=1 and jc1.organization_no=jc0.organization_no and jc0.c=25 and jc1.organization_no=jc3.organization_no and jc3.b=11 and jc1.organization_no=jc4.organization_no and jc1.organization_no=jc5.organization_no and jc5.b=5 and jc1.organization_no=jc6.organization_no and jc1.organization_no=jc7.organization_no and jc1.organization_no=jc8.organization_no and jc1.organization_no=jc1a.organization_no and jc1.organization_no=jc51.organization_no
ORDER BY jc1.gather_organization_no;