select * from (
7 x. w2 O0 w% g! Q8 E1 W! bselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
: w3 @0 o, v" ^! s; h$ {$ }from admissions_data_info 2 x3 l/ \3 T# S5 s$ Z5 W, G6 R
group by business_year,area# o4 |* C5 w, I' ]. A
union all: K; t: P3 D. [9 p' l8 o! A
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area9 E+ I( Z# Y9 I0 b s1 G
from admissions_data_info/ x: ?, b! h9 t0 R' V
group by business_year,area
2 J8 ?, C( [$ k' z s: o- sunion all
4 @; {- U7 A* i# O- q. @select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
" N" U) ^. N0 }# W% [) Z5 T- ~from admissions_data_info
' \0 p8 R5 K, I- y0 cgroup by business_year
) B( d! L% s) l* z9 S: Nunion all
8 m7 F! d# R- z5 ~select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area) F! c! Z8 v0 h2 k( @$ I3 Y6 s6 b
from admissions_data_info& E. n8 Y/ a% h' P" O2 U- f
group by business_year
M% V6 S# o/ P& R/ ?)a
2 M- O- @0 A6 _- v- Q% L8 K; Dwhere area=:area
J0 @+ c& A- v2 R; l oorder by x |
发表于 2020-12-19 15:54:08
显身卡