select * from (
, j% X( T3 R- S% V( J! Oselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
) A5 | f8 l6 _; ^# ]from admissions_data_info
6 z! ^" i n1 u w; z8 x2 ?! `* Igroup by business_year,area4 ^, Z, f) I1 A
union all9 p; [, A. b" c8 a8 H
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
3 u+ l6 d& M) q A. }from admissions_data_info R( z, s* O- [5 l4 y7 F6 R
group by business_year,area
* E5 ?& Q/ b2 \" y$ C Tunion all
; {# \& q' c; fselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
! A) g* r: \3 a/ a: |5 w0 efrom admissions_data_info 9 m2 b8 | K* l# g+ U
group by business_year6 \) @7 p0 P ~- r
union all$ H V) o& `9 Z3 F( d9 P
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
! Z# t8 w% X M3 T0 Gfrom admissions_data_info
$ J7 J4 j. C, R A9 rgroup by business_year
" j, b$ ~5 I& e) })a
" {& Y9 G1 | f: J* d- T- xwhere area=:area
5 u1 k7 U* V: m) `7 forder by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜