select * from (
! E/ Y& A& m; q: u3 P' r2 sselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area9 g9 `( u. e. t) B8 X: E" @
from admissions_data_info
2 i2 F3 x5 H7 M' v: c) r' Xgroup by business_year,area
+ [4 O1 r0 B2 `$ u" |5 W- N1 E: sunion all
) {' T" g. l/ h+ a6 I6 W Yselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
/ M) M$ Q- c# o( u @+ T, ffrom admissions_data_info
- n1 ]' m3 |( O% _( \' d0 Egroup by business_year,area' b0 W' D1 O/ p5 m4 {
union all/ e5 x( c6 o$ R7 j9 [' k4 f: a
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area% L. A: z( j. ^8 h
from admissions_data_info
* T* F. @% e& j& E5 i/ Egroup by business_year! c. c$ {& i; e/ D" x
union all
* l4 l6 Z5 E/ Z' kselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area9 E; g; {6 | A3 g
from admissions_data_info! a4 J6 c& z z7 P2 s9 ]8 ^: `
group by business_year
3 u6 P3 L6 G+ f+ w)a' @3 k* ?+ G1 ~5 l+ a
where area=:area
( s1 U, S/ e2 Horder by x |