select * from (
; E+ h6 M) ~ @( J' U) m6 [. Vselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area1 `5 D# N8 F- J. W) N
from admissions_data_info
6 [% f' Z8 F& X/ Jgroup by business_year,area
9 A. t% \- e# ~ t/ b+ Bunion all
. f4 C. c0 C" [select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area4 J/ j" \$ S! B# E4 P/ T' P# W
from admissions_data_info
, {' I3 A; Y# T" Cgroup by business_year,area
+ S% K% a4 A. U% [4 ounion all
1 E! p% _7 F' Z1 x5 W1 `select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
" ~' T$ t) t% w: `from admissions_data_info 3 B& Q3 ~- _8 F* z5 |& a
group by business_year
7 v I3 O" L1 A! ~/ wunion all
- ?- B4 h Q, @! m7 @select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area. K. k3 L: @; S" ]; b* k. _6 a
from admissions_data_info) Q1 B/ B/ `; A, l6 ~
group by business_year
8 K- m* ?7 B% O' c% K2 L)a9 @& g+ \! `. R8 n, A4 u9 ], j
where area=:area9 C8 _0 R/ {% m
order by x |