select * from (+ O) Q/ A, A- `1 F2 K
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
# h5 i0 p9 ` m) R2 C" kfrom admissions_data_info ) ?) X8 V& |" g0 \& p" B
group by business_year,area
8 j v/ L2 `2 g& ~ p9 J- R6 Nunion all* E1 }0 [7 E- I1 K( ]5 e( i
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
, z7 b! [# S4 P5 K2 t" Yfrom admissions_data_info
# W( \. j7 H. `; H# ngroup by business_year,area1 z* g5 {; {' B0 W7 r
union all
& n- K. [/ X0 i+ t0 Q5 b) Fselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
i* }7 p& w+ D1 O* ~. @from admissions_data_info 7 ^' W# b7 e& m0 `. u, Q" i( T
group by business_year
0 H2 X, y: p) munion all' C% [( v0 I" @$ X) A* u
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area( G: o7 O- ^# v$ l. P6 Z' D
from admissions_data_info
) c/ N7 t$ Z( v: A" }: N+ wgroup by business_year+ [& i, J0 P4 h8 e* y# s( `' I; O
)a! C+ v8 W9 W& ^" _0 t& Z- r1 y
where area=:area
2 q* t# N3 A2 o$ P- d# S; J Vorder by x |
发表于 2021-3-9 11:43:04
显身卡