select * from (
) `8 n/ Z4 \2 }" O$ F; Z' i: Eselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
* y; X: J& J( z g/ m( j i! rfrom admissions_data_info
6 Y4 Q# z) O7 k, V7 w5 }8 Ggroup by business_year,area
% i& X7 w+ j) }union all
1 Z+ C' R7 {, M' j+ f8 t* D- O8 R1 H8 Eselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area" t# m5 m/ x* {* f' f
from admissions_data_info! Y( z* i, o& J
group by business_year,area9 w+ z3 y. A5 _) _
union all O! ~2 W. e4 P7 H @. R
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
/ r" q+ L5 u( E xfrom admissions_data_info * c' `$ R. W* N8 @6 i
group by business_year
/ r( ~+ C4 W9 I$ bunion all3 I9 Q7 e1 Y* g( }: I
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area! b( M/ s6 A7 e% h% Q( \4 W5 ]
from admissions_data_info
1 a0 I# z: H: b; S; a5 a2 k- z$ f1 P9 l/ Mgroup by business_year
4 T6 W9 I% v1 l) j- ~# E)a
; o: H9 X9 [3 E/ }6 uwhere area=:area
9 P0 P2 h) F3 v1 ~order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜