select * from (' F4 U+ S1 I( D8 W
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area; U# d6 y# X+ O% R, ~
from admissions_data_info 8 E% G5 k& R/ S( o/ C) G+ S
group by business_year,area
6 |" C' W3 D, A' Uunion all
7 h Z, Z) v% W, ^8 Dselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
& A9 S4 e- n' h% wfrom admissions_data_info
# E; v/ O' O1 ngroup by business_year,area& ]: g. A% ~3 J) k3 I0 D
union all
/ u1 a* A) `+ G$ nselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area& b9 i! _# o+ j# y) d) J& t
from admissions_data_info
( E7 |4 R: w/ K; M3 ^3 U& pgroup by business_year
}9 j# | |" Y9 n5 Qunion all
) Q! }- e9 i6 ^! F, W3 [2 |select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
: g F0 Q) Z- T' ?: s4 g) c5 dfrom admissions_data_info3 |2 u" D: G6 \0 r: G; P# S: J/ V- i
group by business_year5 z5 K P6 n- v( @
)a. @: v. `! w$ @8 T; J% M+ A6 l, H
where area=:area" c) Z% Y4 N: l- k
order by x |