select * from (' t/ L- L, _- E* S' Q
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
9 P1 a6 W; ?5 t# Tfrom admissions_data_info
9 @4 \6 P# C3 u9 ogroup by business_year,area6 O& A3 I1 N9 t$ _( J
union all
) g) Y) l) X5 K" mselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area$ M0 ]- E$ p! Y" Z% X- A" O/ A
from admissions_data_info$ T6 c, S3 Z/ V% K
group by business_year,area
8 G7 S% }1 e1 wunion all" B2 M7 {( L2 }, f9 O1 Y
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
u/ U9 U; t7 Bfrom admissions_data_info
7 C0 E! x, z% w+ x3 U" B1 ggroup by business_year
9 X8 q n/ n) E# ?' _ Tunion all' V! v: f5 i! }! E" x: O
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
. f' K$ J5 i7 q; o \+ J3 Sfrom admissions_data_info" Q" e3 U; P' b9 U" p
group by business_year
3 ~7 L, @3 d B' x)a: |! J" t% {% A
where area=:area
$ {. q$ y: O: y7 m9 L0 t9 horder by x |