select * from (
) O K* @( J) P, G; e# x jselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
/ Z; V2 f3 F3 i& h O3 Vfrom admissions_data_info 1 R4 p. J: T9 Z, f1 L
group by business_year,area
; o+ p' Z) @- n; D" R& [union all' |9 Z3 N* h, o
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
# \. a) K" r. D' |9 afrom admissions_data_info
/ N5 J n* Q- vgroup by business_year,area
" u, ?7 @5 E* ?7 i2 C" Munion all% f* S' t% i- j
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area9 _$ Z1 n/ j3 D1 S& X' x* a
from admissions_data_info , D9 Q8 p. m) x& m, M
group by business_year
! Y- |. U! B- w% U( runion all& X" l/ c9 \3 H6 b0 s+ R2 @& U
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
) O5 A4 L1 S' j D, hfrom admissions_data_info
4 e2 ^2 S; ~* h6 |( {group by business_year
, `. T% S& s+ Q- l; y)a
H4 D, b# j* R1 @where area=:area
! V/ K6 {! b$ s) s- U, qorder by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜