select * from (8 h; _$ T& W' ?) c# d
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area- i& X1 E0 r( Q2 n3 d
from admissions_data_info # a; b j, V, e' z8 Z0 _! U
group by business_year,area
- C; H- e( [$ v' |7 `* I; h5 Junion all* e" j6 b. T; ]! g C6 ?) E
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
9 t" s B8 [( [- Afrom admissions_data_info# Y6 v4 H7 |8 \9 ^& W( v' P0 X
group by business_year,area* |* `2 a$ [4 P/ j
union all
! A% [+ w" X! Sselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area' Y. p8 m& \6 T5 O
from admissions_data_info
9 l! n2 f$ v' a& q9 s0 Zgroup by business_year
3 h+ d3 r4 `7 ^union all6 |0 P+ d1 N% ~) ^+ G" O% }; U N
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area: S9 t: {* B6 j4 m1 F; J* W
from admissions_data_info/ {, m& H8 N# r' A9 V& N4 b4 z
group by business_year0 P- q* ~8 i7 m+ I
)a3 ^2 p. q4 ~' q; c
where area=:area& s. F& f0 H! E% Z
order by x |
[复制链接]
发表于 2020-12-19 15:54:08
显身卡