select * from (
( X K3 | G9 x3 v, L4 E( Bselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
( ~: k; \5 N9 b: mfrom admissions_data_info + j6 b$ w& d* q
group by business_year,area
! c( ?6 l0 r* s( E( runion all
; h6 ^6 m" |8 B+ n3 C, c# cselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
+ y3 U7 {& |& @. Pfrom admissions_data_info
4 x9 w3 A" L& q8 agroup by business_year,area, D' z1 Y- C& \- `! e" B
union all: s/ b, `* C8 F% p: d
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
3 ^. i' x2 E1 G) Hfrom admissions_data_info " l( `$ @# m2 `: y: Z8 b$ H6 W5 h
group by business_year
( X/ @, P/ H7 Aunion all6 G4 P: W0 ^. I4 z. y; V
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
3 e/ F d. ?6 P% W: o( [8 w9 T& b2 Afrom admissions_data_info& O& c- h/ U/ R
group by business_year
8 N9 Y' l' D: d% r9 b6 w)a: F: [. l' w7 B3 }, r0 l/ {' u
where area=:area
$ n% n0 _5 W1 b9 Q8 `7 i5 i. worder by x |
发表于 2021-3-9 11:43:04
显身卡