select * from (
, W( @% n! f! K1 Q$ p, Dselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
3 i1 y" \! P! r+ @0 t' ?. lfrom admissions_data_info
6 }. X; B4 i" A$ f; o+ d1 Y8 agroup by business_year,area
5 {% r# ~0 w# k* y5 a( junion all% G: l0 f' [- c
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area% h, y0 I4 }0 ^% a4 }3 P# F7 y" M
from admissions_data_info
' m& h! m% q7 u6 Z* P0 D' zgroup by business_year,area! p7 }( }7 {. c7 r/ N0 H' b
union all- d0 E4 F3 f/ k* S8 M8 L3 Q; m5 n( [$ v
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
% y+ }( W, n" t: P8 l) Hfrom admissions_data_info
' m; g+ c# n# D- Egroup by business_year
+ W9 G( T! }& g2 l' I( a5 uunion all
' A) R/ P" @; Gselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area; b4 Q7 {& O3 u# l( k
from admissions_data_info, D: y9 V* _, p+ G5 H! d$ F
group by business_year
7 Y( D5 ^0 x. m/ f+ `: w$ `1 `/ m' Z$ b)a
# u, U; M) R) e: \where area=:area2 Z& ^0 ]4 h. l) D' N5 R
order by x |