select * from (
* ?4 g+ a# ?9 gselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area ~0 Q ], n: s3 ]% x' Z
from admissions_data_info
& U$ x2 @( C- U8 m, t' ]group by business_year,area0 V0 [5 w0 x0 \/ o: Z
union all1 V: b4 p3 x, z0 n9 @
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area/ G% t* v/ N! k/ q2 [* d! z
from admissions_data_info
9 W/ y$ B4 w/ u5 b; E+ J/ R2 Xgroup by business_year,area7 y$ n; o$ R& m
union all3 j* k+ H7 U& f$ h: p. ^. \
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area! O' f( _* Z& n
from admissions_data_info
2 d% q7 M8 @, L, D2 Bgroup by business_year" g; c5 x: b2 q
union all
. o# k) P; y6 Z0 d/ _: }8 Dselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area) g% p/ i2 }! T3 D* c
from admissions_data_info
/ _* l! Z& p( \, `, }$ \% ]group by business_year7 T1 L9 V! n4 w B6 g% L
)a
( h0 |' U& O; X5 _" |$ h+ a" uwhere area=:area/ E+ P# X) g( w2 _. p, A* v
order by x |
发表于 2020-12-19 15:54:08
显身卡