select * from (
. u- o: v. n9 P1 I! V: I3 M- R iselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area- m& \0 ]! ?% U6 I: j
from admissions_data_info
* C: A' O: \6 {4 R( k5 D" Ngroup by business_year,area
$ e0 q+ M' ~% v# _union all
+ z! `% O8 ~2 F+ }# [( Dselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
. f+ S) e& i9 r6 M$ ?from admissions_data_info4 y8 p% U7 |/ y, O8 l! x
group by business_year,area3 Q/ {: Q. f: @
union all
; B; s) E1 L2 H5 r7 aselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area- ^$ m1 U# M6 ?( S/ a% b% \
from admissions_data_info $ T$ I9 P3 q/ i: G m) d' F
group by business_year4 E2 b; K7 C) w4 x( N5 ^) s
union all
+ l. _$ f# f4 q0 pselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
, |/ R, @; _: }+ k% |9 b) j, W9 A" {from admissions_data_info
* c' c5 ]% g9 c; Igroup by business_year/ e# ?8 g$ j. X+ G
)a0 [# {* b) e$ r) t1 |2 {9 y
where area=:area
. B5 _9 ?% D) [) C' Xorder by x |