select * from (
& |9 O+ f4 ~5 zselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
, @3 C5 k. J- \7 q4 _, {9 ]from admissions_data_info $ } u& C) {( |* P) H# b( h
group by business_year,area$ C( {1 b3 G7 p# ]0 |4 P
union all8 I5 X4 y6 [, z5 l( n
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
+ Y+ E' w# d2 ]8 I' x hfrom admissions_data_info! }5 ]0 X; S7 J
group by business_year,area. N8 j& g1 @6 C& b9 O
union all
y3 G3 |( f" l( B9 vselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area+ I$ l& ], q/ ~% A8 s# k
from admissions_data_info
5 `" f& {4 g& ~group by business_year
\; v5 R7 E9 @2 wunion all
# w$ |3 N" h9 a( vselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
$ t( \) }+ ~" ^/ f/ \from admissions_data_info
+ H/ R8 y. k0 S( X; L. ngroup by business_year
; t. R% L; @. R% w3 \; [( A `/ _)a0 x8 ]$ G* |7 E ]9 w0 |
where area=:area
9 ]7 X! F; [% U& }4 K _order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜