select * from (! ]+ v3 p: m* d S! @; X% i1 ?. s
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
5 ]) d/ Z' b' K. O/ pfrom admissions_data_info / ^' p- K$ r4 N, A* J" J" F
group by business_year,area
7 R) M, X5 G2 f4 s% w& N8 Funion all
( ?1 ^5 s3 @ y3 k& I" {+ I5 O% Yselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area! c n/ {' h( h
from admissions_data_info- W5 h4 y* g% |7 I& S" M; \$ P
group by business_year,area
/ w2 J7 ] l4 E$ ]8 T) Z( cunion all2 y% a/ e9 q b
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
8 P5 Y9 j3 \, w, Xfrom admissions_data_info
2 U1 g$ q- J5 S( O/ rgroup by business_year
l& [" B. a* L2 {6 z8 i. Munion all/ w* I0 r( Y! A% z; Y% l0 J
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
0 S$ F, i* i2 X3 Mfrom admissions_data_info
4 [. R3 ?; v; s" h% Ogroup by business_year0 x; F. {8 c$ }# A1 g
)a
% N; z; E. e! K. k* Qwhere area=:area
9 N& }7 S; S: I: Border by x |