select * from (
8 C2 q5 |1 N1 K* U' E( tselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
" X7 z: M0 g) F! _from admissions_data_info & {; r4 a9 I+ M! E5 b2 U
group by business_year,area, r" z# r% m% z* c/ U, ~
union all6 f9 p5 x: V2 y+ k' m" h" m9 M
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
+ X' \; O& Z6 B7 h# S7 a; j0 ofrom admissions_data_info
* N3 |* ^8 w" ~; Z9 {* rgroup by business_year,area" |! Z/ [7 p4 @
union all% T: n+ V8 W2 m) N
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
& H2 x) a& Y9 D" a. M. Efrom admissions_data_info 5 j0 o( X# e8 r
group by business_year( K4 S3 ^3 x, q" O" w6 ~0 l. N* H
union all* \: q1 Q' I, Z! q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area3 H. f- r8 B! H2 @+ R# f9 S1 M8 \
from admissions_data_info
T- |1 q" Z2 x, ?" egroup by business_year
4 o; a. V8 Y4 ?)a$ Z1 O+ C. G. J9 Y/ J
where area=:area
. W: r6 Q- b/ n. {: Eorder by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜