select * from (8 t; V% t# A6 R
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
- l% H+ T- f: I ~ mfrom admissions_data_info + I6 \- q3 l$ f/ X8 z# o8 J
group by business_year,area3 ~1 i$ r" f2 |/ F! |: l0 }/ r" t( y
union all" u. Y c, E" x0 d; B$ h0 P
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
s# a! L4 ^) |( wfrom admissions_data_info8 _( L# g+ K: m q! V
group by business_year,area) B b8 @" p4 Z8 S5 A
union all
8 d; A: \4 B% B7 c! rselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
$ r' `8 F0 J3 X2 |' u( Yfrom admissions_data_info
& Z7 t) _+ z/ j2 g9 ]% igroup by business_year3 i- z* {; t3 y" R4 r6 u
union all
7 I: L4 \+ m4 iselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area. _9 x! R) q7 e) Q
from admissions_data_info. ` l8 Q i9 D- c! K
group by business_year
$ \0 f& [' J" a7 i- C)a7 l) ?" |8 Q: N; R) A4 V# t3 m" a
where area=:area4 b6 s' D& i* I0 m) X
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡