select * from (
" s: ]; s: r1 J& s( |select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area5 `! f8 p/ Q: s* v u
from admissions_data_info ) T w% ~, T- S3 e0 c( @1 j/ A! |
group by business_year,area
2 r3 o; k- z5 l. T! o2 F7 ~union all
2 J. _- N9 G) V D+ @select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
2 D4 {5 \5 ^% X) y2 a: nfrom admissions_data_info
2 u6 _! F. {" F2 v5 |4 {* T( rgroup by business_year,area- d3 b8 y) ~2 b, K1 V, S1 R
union all1 s! {9 P( I# u
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
5 x3 a+ H' a; }2 m0 bfrom admissions_data_info : M" o' w( u C$ U
group by business_year
0 w* ?5 V: e3 I9 ?union all
- _+ ? t, k3 tselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area+ J7 m/ y$ N! R; F; ^
from admissions_data_info
i# W8 c! d. _, P7 Ugroup by business_year! Q) n5 e u' g
)a; L! b' [, r+ R1 V6 W) V
where area=:area
1 ^6 N" Q7 d9 Morder by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜