SELECT sbr.organizationNo  ,1 as schoolTypeGroupNo,'一、高中阶段' as schoolTypeGroup,2 as schoolTypeGroupNo2,'（二）中等职业学校' as schoolTypeGroup2 ,sbr.businessTypeNo
, case when sbr.businessTypeNo in ('369') then '其他机构（班）' when sbr.businessTypeNo in ('368') then '附设中职班' else sbr.businessType end as  businessType 
,sbr.ownertypeno ,sbr.ownerTypeGroup ,sbr.citycountrytypeno ,sbr.cityCountryGroup,sbr.structureType,sbr.populationGroup,sbr .isnation , isCount       
from schoolBusinessRelation sbr where  sbr.gatherRegionB ='长春市'  and sbr.businessTypeNo in('362','364','365','361','363','368','369')  and sbr.isLastYearCancel =0  
order by sbr.businessTypeNo;