select * from (
9 S* r; _* ?9 S$ gselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area3 U; @# U3 r4 `
from admissions_data_info & p7 T7 R5 I3 T- s+ O1 D2 ~5 [& L- x6 d
group by business_year,area
8 R1 s2 B- Y- O( tunion all
\( {9 o2 m E0 W# U. ^select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area3 i4 d$ n. s6 |5 B* A
from admissions_data_info E4 l$ C* Z7 g q" `
group by business_year,area
2 p( O+ V0 e/ c5 C" f1 E; \" ~3 nunion all
% O0 m: H& m2 W. M g* Hselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
+ x8 M# ?, E; Tfrom admissions_data_info
; u: g$ H, \ `/ t1 Tgroup by business_year
2 s5 [ X! ?. Y+ V; k$ iunion all4 y/ k* b. G0 I8 |& x& g
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
7 X& t0 }0 e+ [9 x5 [' c. J vfrom admissions_data_info1 z0 a4 ]8 w, {2 U1 X
group by business_year" b' ` I w ]* f+ i; H9 q
)a
$ U, `. B% U O$ F1 k) `) i7 v# h5 fwhere area=:area1 e) C% i4 |7 N
order by x |
发表于 2021-3-9 11:43:04
显身卡