select * from (
$ W+ X8 p! H; C+ E/ f3 }9 \select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area4 L D4 z( _% D3 I/ Q& I$ u' t; S
from admissions_data_info
+ W. a$ \0 q/ l7 v( g) Ugroup by business_year,area. c2 C3 e! U# {- T
union all- d- j8 q" p9 }$ d9 ]! D
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area9 ~/ w1 D7 E+ j/ A
from admissions_data_info
* ]1 W. b3 }* L$ W' ~5 u$ zgroup by business_year,area- A/ l( [& @0 q: [2 e( t
union all7 C0 B7 }" U9 a) A1 b) b3 k3 `
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area' d E3 d5 n* S6 x
from admissions_data_info
% j c4 I0 |; X' A! |0 Igroup by business_year- X/ C* k# K. {5 U# J
union all
, \, s. W! {, S$ P! cselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
/ m" Q. P, g0 @+ Z% r! R$ X% {from admissions_data_info% B5 \4 W! y2 a, q
group by business_year5 ]+ t R7 M" Y4 t
)a
5 T+ e( y$ ]6 E9 V% ~9 Owhere area=:area
. G2 U: Q/ |# Uorder by x |