select * from (
# {0 j3 W a* y/ O7 Pselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area% f# N) c! [( q5 \
from admissions_data_info
' u3 @7 \8 C1 p4 a2 ]- bgroup by business_year,area+ w2 p1 x$ ^" o5 p6 G
union all
0 ~, f. z# S Jselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
6 [. V# J2 f: z1 Q* |2 y( N; Afrom admissions_data_info
! l& P) z7 B$ ]group by business_year,area
9 y9 @) p7 v! p! Dunion all
6 Q, P& b L8 q2 }9 f! p4 Nselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
4 p% m: c" c4 D* K& c% d% J8 sfrom admissions_data_info 5 B3 Z; F$ |+ o% K
group by business_year" z2 i* L" i! j. p* A* R6 x
union all
: o% T- `, `2 a% ^. W8 aselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area5 V: a8 T$ Q! q7 s) Q2 N
from admissions_data_info- a4 L, S! f( f3 C! u. x9 x2 D- D
group by business_year5 C1 A, y7 I+ ]( k: p0 n! M
)a+ q/ x8 V4 m; y, \+ x1 x1 X
where area=:area
$ X; A; `4 B4 r6 S a1 |/ Gorder by x |
楼主: 干一炮
发表于 2020-12-19 15:54:08
显身卡
