select * from ( k, ~5 d# l; b
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area" t4 e) j4 ^5 x6 {! y4 ]" Y' |6 T
from admissions_data_info & C4 N" X* g5 T% M5 x. i
group by business_year,area) O8 a3 K! M3 Y# d( T J9 X2 m
union all
, t: W; Y9 t2 }. y7 E tselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
: z. U Z# R( x7 ]) y% [from admissions_data_info5 ]0 U$ |9 |( s
group by business_year,area4 [ Q% g: q- O
union all+ W! ~" V$ ~9 }8 G! e' A) Y
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area( D- ?8 j; x4 x- T
from admissions_data_info 6 h0 u: R) h* s! I+ y) v9 Y
group by business_year$ n# Y% \ _0 I8 C X6 Z
union all
+ Y6 e- ^9 n7 h+ \9 Tselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
& z+ V' g6 _; x: \from admissions_data_info4 o8 H D7 k0 j7 B
group by business_year* r6 Y6 D( w4 w8 r$ N/ k
)a+ T. X; c" v$ w7 S
where area=:area8 } w" F% ~: Q! }, o
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜