select * from (
4 _* G4 F1 t; a2 N0 Yselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area3 ~: D! ^+ q; e y9 e3 M4 b; O G
from admissions_data_info
' q* ^: x2 {0 [/ C2 o+ _( bgroup by business_year,area
2 l' Q9 K. Y; B6 E! g5 ~, @' ~union all
Z: c9 I( |8 n) q5 @select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area/ e3 {5 _" m9 |( A3 t* Q
from admissions_data_info" o# Z" ?! M) J- O, \
group by business_year,area
8 ]& a- ^; G i9 Z( ?union all
/ o1 w, ?0 F& I4 _5 N" R/ ]select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
3 l5 j& C' w5 H# w/ E8 ufrom admissions_data_info , G0 @: N; l& e9 o: ^5 @* e( s
group by business_year
# j2 U, K7 `( U4 o% I! @+ c7 hunion all
4 L% s+ o& T3 u2 Y% k, j7 Aselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area# D N4 E% I! m8 m& [- b1 W
from admissions_data_info: |9 q1 r+ D' ]* m! |! ~
group by business_year
* p6 \. s! a0 y9 b6 {)a
1 c: |4 E# q3 n5 Mwhere area=:area
5 G7 Z# Q$ S: R, Morder by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜