select * from (2 V9 G9 t. I, q( D. V3 o
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
& \% C& f/ C2 g5 Mfrom admissions_data_info
8 _1 ~" [3 R/ u ?6 ugroup by business_year,area
9 c) v6 @5 o: P/ p- Z" F, runion all
0 m/ P* i0 i4 Eselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
" R/ ?& z! z! v8 Q/ \' h1 Xfrom admissions_data_info
) k0 J7 Q2 S; w( E) N7 Cgroup by business_year,area
& Z5 _9 s4 w' k( V- w& l) Munion all
# E4 E- n$ |! Sselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area0 U) x& _+ i) C$ s( g0 W
from admissions_data_info
3 U: \8 J4 c7 J5 g- X0 Cgroup by business_year
y& F5 }1 L1 Y2 o7 P2 Uunion all* H3 e8 b" D# J1 Y, s
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
; c8 |; c3 j. n/ ^0 O% Xfrom admissions_data_info+ m! _( p5 q$ j0 J
group by business_year
3 I+ y: k/ ], r |$ P; f)a# g" ]' G1 f: V5 z2 E; Z
where area=:area
, i% t+ A, r# X+ ?" C$ n' morder by x |
[复制链接]
发表于 2020-12-19 15:54:08
显身卡