select * from (
& L- ^" T& y" jselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area' x- R: W( Z' T4 |, }
from admissions_data_info
. P( y1 U8 ?& X1 M& kgroup by business_year,area" {2 C8 M, e- L v# Q1 _9 ?1 v
union all8 q5 a K& ?: [2 q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area/ T& F ]" E+ N7 j9 D( G J
from admissions_data_info
$ X7 X+ g' ]* Z' Q/ m% b! Kgroup by business_year,area' ^. t" P1 U2 j" p+ v
union all
$ c+ K) U. G4 f) _& S$ u# \) `select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area- T) \3 B; M6 A, s: V/ a
from admissions_data_info
8 ?4 q" {# E3 R: _4 m) Ggroup by business_year+ V! R* V: C* X, D' Q( e) f: N( f
union all
" y6 N0 b, N4 D% \1 Fselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
4 g2 z0 P! s: \5 }6 T" Xfrom admissions_data_info( Y2 Z5 w- ]6 x- J0 d x# v
group by business_year' z) \6 g7 r( W
)a; ~4 q2 |+ n1 p+ |9 D7 \. `, c( s
where area=:area6 g: p0 |8 g$ K8 L8 Q, |' l
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡