select * from (% B! E6 N7 @! S, n! L5 ?
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area2 Z) p. P( x8 M) S
from admissions_data_info 4 |5 U. p; Q! d% [% T
group by business_year,area. v( K" _9 s( H2 T4 m o
union all1 b" p- U) X" q0 p9 y
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area" A3 D/ {& }9 A. u+ g
from admissions_data_info
6 }3 O: z' w( Y, Q% V% Ogroup by business_year,area
4 f2 _1 c% L9 `union all9 E6 D+ N5 O9 S; G2 h# P& `2 R
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area6 y( }. E2 U7 Q5 h) h! S* y9 N! z
from admissions_data_info ) W* U. W: A1 C" j e
group by business_year( B+ i9 }- I. ^! i
union all) `* N$ G" w3 Y' E$ q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
" m; F' Q! e$ W4 V1 N$ Rfrom admissions_data_info
) \8 T" \& k6 m2 Kgroup by business_year- [) X+ w, _- d
)a0 |; D- y; U% {
where area=:area$ ^7 |& ^# i5 E! W+ |1 A
order by x |
发表于 2021-3-9 11:43:04
显身卡