select * from (
# ?3 o/ o9 d6 {$ \8 w0 gselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
7 ^) f* N' n2 K/ ~from admissions_data_info $ E# j/ x, L0 L: F+ `. ?
group by business_year,area& p1 _. w' a! w# G! n) z0 O
union all
1 Y9 V$ C( t% K* q$ T/ ]- l, r5 g& iselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area8 Q2 W; \9 T: P; l; f2 @5 Y- J
from admissions_data_info! n4 ^! J$ d2 B' s2 p
group by business_year,area
8 \( `6 ]- G$ X$ W! Munion all1 [% _; g; [( C6 m! Q* v
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area; w. ?7 _7 P1 e
from admissions_data_info ! s6 C. @' E) {1 v! ?4 ^8 \ H2 U9 @
group by business_year
# Y: o7 J" W; i2 h6 `union all2 u) v& e# G' w4 N' H& k( d
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
; B0 s- v$ n5 d' w8 M1 `* X- ^9 Ufrom admissions_data_info! k* X( e0 o, _7 ~& r
group by business_year
3 m, Z* Q4 |& B4 z( Z9 x5 H4 ? N)a2 t0 L: c6 Q: v8 T- m; K
where area=:area
p" s' N+ L4 Horder by x |
发表于 2021-3-9 11:43:04
显身卡