select * from (
. F n/ p- T. vselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area+ C- Y* ?; F8 q: x; ^
from admissions_data_info
2 C9 V S% q: A$ M' M, t0 zgroup by business_year,area* N% ?# Z5 T" q5 J
union all! I, n+ q2 x: S& X5 [" U
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
4 y3 g! d3 O; D! ~$ k G$ ~from admissions_data_info1 y. s1 o5 R f# N+ U2 R, d2 G% u5 N
group by business_year,area
/ r( V9 a2 a9 T6 @0 S& E$ Bunion all2 \: ?5 m$ y, j$ m L( K
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
( Y, W# J( o0 O/ p& xfrom admissions_data_info , K: m( i, y+ s( M$ r W/ y) h
group by business_year; D* q+ G3 @7 _$ Z, t; Q
union all# K O8 R4 @* B- b |' u
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area5 Y! P2 m; m& F3 |/ q4 }% X
from admissions_data_info
, j1 O$ N" ~/ r0 ?! m0 pgroup by business_year
& b* r, V; f2 c$ `6 q; `, v: j)a
! V* k8 r- m& Y8 K/ X$ iwhere area=:area5 B y4 G- v+ t5 J0 {) G8 W
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡