select * from (1 W% o: \2 u* K0 o3 H D
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
* Q; o i( f, A1 Qfrom admissions_data_info : t- e9 E% Z$ {, ^$ S- K
group by business_year,area
7 |# b1 C' g" a1 E' I; x+ yunion all" ~7 W: C d2 M! G2 V! Y
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
6 u( C! P* i* X4 F0 zfrom admissions_data_info: I) @; Q$ d# e3 f% g3 E5 M
group by business_year,area& C- d: s& a, a4 E) C( M2 g
union all
. u) X6 p$ h, N$ `! Y: t, @, o: sselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
+ a' {/ y* j, \* ]) s1 B1 tfrom admissions_data_info ( k0 h+ P2 h% Z( X# ^" W
group by business_year# V) e" T, c" e6 F& X# M$ G+ a6 S
union all. m+ o3 {8 Z# W, r s5 z' x
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
5 }% l6 r( M# \( M, X( v7 pfrom admissions_data_info* k9 q& n2 y' C' Q' b' S
group by business_year
* V6 N7 q( Q$ h) N& _6 B/ N)a
1 p. c" V) ~0 s# zwhere area=:area( L) c: n0 k# a' Q& u0 r
order by x |