select * from (
5 O0 W! X j' E. X6 p& zselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
# v' t$ _! S, w9 I# Y& `' Bfrom admissions_data_info # u0 {: {% m* `) @
group by business_year,area
9 W/ V G }" I) |union all: r9 ^! _4 ~, ]0 d
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
, }* T3 r8 W0 e7 u& hfrom admissions_data_info
9 M" y( q7 J. X$ Tgroup by business_year,area3 x4 f8 c' S, A- _ g
union all
8 q: Y9 M) ?% Y4 |5 Yselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area! h' K5 D0 w0 J
from admissions_data_info
|8 n+ s+ n6 ^( Jgroup by business_year. I |6 D3 v$ c! ]( @
union all
0 {7 ^6 v3 m. m. W$ B( yselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area2 ~' s! F0 D0 U9 f( x1 ?2 I! ?0 s
from admissions_data_info
: V% u+ N1 w1 N& m- [7 |- ~group by business_year
# S' ]9 P1 g7 E( u( l)a1 ~3 m+ c3 w, n' b! @) s. \
where area=:area
/ F& Y) y3 u& e1 M: l1 E! Sorder by x |