select * from ( H1 ~: x, [& M
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area" U. ?- F0 Z( `
from admissions_data_info
5 v0 [/ V7 b( O1 |* J: H5 \ L, pgroup by business_year,area V( L6 e1 Y$ h5 {: E" a# E0 k
union all0 U8 C6 y/ y9 r7 t/ @! V) w; Q" t
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area! M/ \7 z) _* C, D2 G( b
from admissions_data_info
: L" l( ^: W2 m& U' l! h* }( Igroup by business_year,area
$ \) I( Q) g0 n; O5 X! r/ ?union all( F+ J/ f- R2 L+ A; K0 j% O) y5 u$ ?
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
. y! \" E( o. D( l; V8 V7 mfrom admissions_data_info
6 n0 F* {8 O) L2 Dgroup by business_year
/ s! M- Z) E. @- ]2 e9 Aunion all J$ k, ^9 u4 x& ]- k; A7 J3 M s
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
# n; p. }/ d) _ U4 `from admissions_data_info
$ W5 X' {4 Q' h7 U# l" Ygroup by business_year' U+ X9 N# I8 X/ V7 c! g6 }
)a
8 _$ g) W8 t7 Z6 Rwhere area=:area
! F; L% t0 l$ Z# \order by x |
[复制链接]
发表于 2020-12-19 15:54:08
显身卡