select * from (
. ]1 z% ?1 `7 }# ?, Lselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
' k% v0 h& k/ ffrom admissions_data_info ' Z/ _2 N, `+ q7 S3 m7 F ^2 h
group by business_year,area* t2 w8 M! j' P2 i7 Y
union all
! ?5 l) {+ s3 Dselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
6 g3 K+ w5 i; ffrom admissions_data_info5 Q8 o" Q# ?2 B: P [9 @
group by business_year,area- v2 }, H! ?5 @9 e8 @/ j
union all
" b1 K% o/ q% |7 g Aselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
7 t3 m- G+ w# r5 |" dfrom admissions_data_info
# o+ O$ ?/ s! G9 M7 lgroup by business_year7 x [! |$ c0 C Y! ?
union all- R, y# o/ y: O
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area5 Y' r ]' ?- V! Q4 ]
from admissions_data_info9 h$ j# \1 k6 Y
group by business_year$ O9 i4 ~: ?# ?
)a
' R9 A% _4 v; L! rwhere area=:area" z% {* s8 u) C; n. B$ q0 G
order by x |