select * from (
0 }& I. n, g0 e) C y3 pselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
: J! c+ o* Y6 {" j/ @3 i+ jfrom admissions_data_info % O; ]7 t- D) N* ^3 f
group by business_year,area2 {( ^7 d9 S1 H* _* p5 }& X Q0 b
union all/ @* k% h D5 X( C: B& L
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
6 \3 I: g# l2 G: e, p% Ffrom admissions_data_info6 w$ A) b% N6 P
group by business_year,area: i4 _) |; ^6 H* p
union all
9 B Y) c% d2 {3 z8 S1 Yselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
7 H# H& B4 |2 l9 kfrom admissions_data_info . b0 f3 S2 C! ?, A* W* K
group by business_year d" J& D2 Z# u" w2 U( r o
union all) j. v# }( Q$ U: d) W) e% q
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area5 b% L2 N9 r) d, h( R8 C5 q
from admissions_data_info3 \; L# C% G# S t# ?$ Z
group by business_year* k7 a9 |4 Y/ [0 w
)a6 t1 I9 W. }+ _9 O# `/ L) [
where area=:area
- V% ]( }( `+ _9 |7 worder by x |
[复制链接]
发表于 2021-3-9 11:43:04
显身卡