select * from (; o) B( P* V0 u2 M3 a* L
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
) V; @# u2 N+ F- T2 Z' b$ }- ofrom admissions_data_info 4 ~7 D. x" V, |/ N" C' u- O! \
group by business_year,area& g6 I# [; f3 U3 J$ T" q7 }4 Y0 }/ }
union all* Q( B- S% y4 i' d& L& h, w) ~# r7 Q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area4 j. w; z5 U# T# v
from admissions_data_info
4 h% K' Q+ X! a# F2 o7 k' g3 [ p" {group by business_year,area, l% l! N9 E+ E% _0 o6 Z
union all$ S# T6 @5 ~+ Z+ ~8 q3 f
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area! B( k4 q8 E8 R9 n/ C J( X
from admissions_data_info 3 J: r" k% _( @
group by business_year3 n! C7 k: A1 R4 m2 L6 y
union all
2 I; h; }& K; N% \5 Rselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area% O+ K0 _+ z" L; E- E1 |
from admissions_data_info9 i3 s C G9 O( e# s. A
group by business_year
, X: j; \5 @. B)a
1 {$ z) x5 A% H0 c ?, ]- lwhere area=:area
5 d$ V9 p7 T! Y4 uorder by x |