select * from (
& O( e: ?9 K; o. I. P7 wselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
1 b1 G( y: i, ~1 e/ n. Yfrom admissions_data_info 5 p# l( c& J K/ D
group by business_year,area
1 Q; X- G3 z- p0 f( K" {9 [union all) W$ C9 c: u# k) K {. Z
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area9 G4 `) W; A' \6 N x2 v' m
from admissions_data_info+ {" I. B: ?3 G& H' ?% _1 y
group by business_year,area
: f F0 v3 C2 y6 K& e' Dunion all! T! y" @: T1 Q+ u6 D7 t) n
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
2 f* ]+ w( M! S3 dfrom admissions_data_info
5 X9 D6 b1 m6 z/ c4 rgroup by business_year
( M) R A" S8 s( ]: |union all
/ M) c" Y0 M9 {. {select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
3 T9 P) g: G, tfrom admissions_data_info# b ?* @4 m/ e6 j' o
group by business_year# n& _- }5 Z8 }+ |
)a. {. g, w U0 X6 s/ k& K7 E
where area=:area
) |3 d3 p3 [% D# T6 n9 sorder by x |
发表于 2020-12-19 15:54:08
显身卡