select * from (
3 v; k8 _5 K2 p0 vselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
5 ]: g- ?5 r( n& E }1 [: s3 v* nfrom admissions_data_info 7 ~6 k* W. j: U" ^& h2 m
group by business_year,area m. J4 F @+ f) H+ K. j
union all1 V$ f1 P3 C6 s5 e% ]) h* Q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
/ O6 u7 ^- A; g: u" r% Y* a1 ]) |2 w0 Lfrom admissions_data_info! D* x8 D7 M1 I! G
group by business_year,area. E2 y; n3 z: n
union all
# C7 l* N+ h4 T% g6 Z5 V5 nselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
7 f/ e, D) }8 R7 w3 s' a! \from admissions_data_info + B, D' @+ @/ b0 z1 v
group by business_year
7 ?" ]2 [* R" m% g* Eunion all
, Z' U' A- x y; q P+ T: y" bselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
/ Q0 z6 f, P$ l! w4 `from admissions_data_info& S- W1 X& S& [ m
group by business_year k. y7 e3 [' E/ m, a* G
)a
" D& H1 F3 {5 p: q5 y" _% xwhere area=:area' _" I0 U# m \! z8 O2 X* l! `
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡