select * from (8 l1 _( @9 q0 w
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area* g; j( N8 X4 M/ i3 c/ Y& p* Y
from admissions_data_info $ \5 j. U0 X3 |0 N2 O
group by business_year,area; u; H1 @9 g# `$ F
union all- {/ j+ O6 L( [, s, _* @
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
4 C2 U/ f: I) l! o0 I( X/ |from admissions_data_info
: R/ B& W; }. ?" k/ I1 A6 n' rgroup by business_year,area
M n- K2 s9 g) X; M/ [union all
7 s5 V6 X: D7 v1 ~select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
4 H" j) Q& Q5 Rfrom admissions_data_info 7 d$ c, t0 o o. d8 o0 L
group by business_year* c$ y7 S2 \& g) D+ c1 c; ~) S
union all5 ^8 f2 ^1 s* a T, a- x. c
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area; U' |+ D E. G. e/ X
from admissions_data_info6 _( B" ^* `$ @$ Y% u* L
group by business_year
. J& C! G; N0 c6 i)a
2 ~% k( \& M- _0 {% f4 S) Z* l1 d; Mwhere area=:area
/ S8 X1 x* r8 [% S6 Q' Eorder by x |