select * from (! \( ~! e, k" |, @) }2 r0 X4 R- L
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
' M. O: }( ^$ V" e) B. H1 W: vfrom admissions_data_info ' k* }+ m% ~! t, d/ E" T' ]
group by business_year,area, q' t. E1 O- a2 R w
union all; q( a0 W' h0 T1 H v/ W- p @6 f
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
+ B D8 p% P& b3 t: n) ifrom admissions_data_info
! R% C- t) F7 Bgroup by business_year,area
) a4 Q' p6 ?* X/ r9 G7 M' Zunion all& A( k5 N' u6 K& a' L; D3 [4 M$ a
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
; h( g' U, K- C3 U# |9 ffrom admissions_data_info
8 @! a- @. z: Y7 {6 Q: _2 \ Zgroup by business_year
, r" b4 [, S* B2 @3 F- s: ?union all8 v X- w, S, G7 q& S; r! s
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area% X/ R# m$ p3 E' B( a# {
from admissions_data_info( g4 P( ^- X' U: k3 b9 v, J
group by business_year% ~! ^0 ^0 X5 T& i8 l5 M* }
)a
5 c6 B0 Q4 v" R5 o; P8 qwhere area=:area
! D- ]! d8 v8 ~! ^% j$ i7 @order by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
