select * from (
2 \; ]3 Y6 Q8 F3 {% M! z' h2 L1 J. Hselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
$ k4 u4 \% X( x- g* o/ u9 w' Yfrom admissions_data_info 6 j+ R. c+ V/ N6 D
group by business_year,area6 [, \1 o0 j* H% o( `
union all
/ h+ y# H$ M* ]( Yselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area1 g# D8 D1 Q5 \$ Z5 C* U
from admissions_data_info
3 t& B. ?2 ?! P" Z) O/ X- Ogroup by business_year,area
, t% t( H" w. W& T6 z" \# E, [union all( r& q0 L6 J) Z# {
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area( C- d* y7 d7 E5 I
from admissions_data_info
* _8 O9 R* q6 ^ Igroup by business_year8 J+ ~3 J$ S4 {( h% r6 E# O0 }$ U
union all& j/ G v/ M* i9 y& b0 [ @
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area4 s/ [3 Z6 V \% C. h7 N X
from admissions_data_info/ q$ @( X+ T$ ?$ H9 T: b5 P
group by business_year
; D$ l) n5 X& X)a
( d; j! [* Q) w1 u2 H7 Rwhere area=:area5 O1 K* F& |( Y0 ~1 A
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡