select * from (7 q( |) l5 P L* A7 R* x
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area/ C4 f6 L G. L
from admissions_data_info / p1 G' s! f, D% n9 K* B" H! G
group by business_year,area
9 T5 ?5 n Y: z/ _union all4 g7 ~7 M- s# {8 F& j3 I0 _! @. C
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area! v; z1 h) }9 z( Z+ s9 w2 D3 ~
from admissions_data_info$ t" c" r; K4 H u5 d3 O
group by business_year,area" m) ?+ K) [1 b
union all. C* Y* i s1 u- v9 Y% ^, ^
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area$ u, @8 d& a l2 q7 r( A6 J
from admissions_data_info " M: \' r( R6 ]% d
group by business_year: ], i! V& u7 D6 E! ?3 Q V
union all
5 I% T, ]3 F. h8 tselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area& ]' }5 \% P% g* S5 p) [' d) a
from admissions_data_info
5 \8 H$ N7 a9 P& g% C: Zgroup by business_year" B, O$ k1 m1 ]+ W H6 a- J
)a
+ o- R0 G& u) m. Ywhere area=:area. _) v! w, k ?& m
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜