select * from (8 s7 t! X; r+ h! u) W b3 {" Z# k
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area0 p, P& l& i* j1 l
from admissions_data_info
5 G( |7 C1 U/ v: Q- Y% k" Agroup by business_year,area
. Q0 e+ Q: j/ k8 A r: cunion all* g) S( W. r* K( u% |
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
$ k$ t" ]" T7 P$ X0 @from admissions_data_info
: P i& [! [$ [4 U2 V. C+ @, wgroup by business_year,area6 c7 \" h) n* W6 t, X
union all
0 J. J4 z: n6 a0 k4 N5 Qselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
7 J# c' y7 H( B3 h$ `. X; Dfrom admissions_data_info + @# ~0 e0 T+ L/ F3 D! Y$ M
group by business_year
( f: Z8 z& u$ d6 n& i1 z- o8 Vunion all
9 S7 \2 n* [( |0 C C; ]5 D# Q5 [# rselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area, o1 i4 ~; D9 x8 U+ d
from admissions_data_info
& D& P0 D6 U7 Hgroup by business_year( p1 X2 j X/ |. k3 e2 b c& E, v
)a
' U) k( p9 m0 Y0 i! K$ Fwhere area=:area# ^4 l3 M2 K4 z9 ]" h& w$ n
order by x |
发表于 2021-3-9 11:43:04
显身卡