select * from (( ]- G, s* b, f" \! m# E
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area" j, ~8 _+ _% Y- _ n0 J
from admissions_data_info
8 U: t- ]. R7 j* _& t; \# g+ pgroup by business_year,area
5 g; m& A7 P5 Y" S8 \; }union all- c# u4 t& ~: l6 n( f0 H5 z
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area* n( h, I* v5 J( W }" T7 h
from admissions_data_info% M# f0 I* d8 g. L7 F0 x
group by business_year,area* P N# u4 Y$ b# E, G( K6 A) w8 v. u
union all
( o; C" h: C5 b+ gselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
' J, Z4 f) }8 p/ W7 j1 \: ]$ K8 r# Afrom admissions_data_info - G4 | @% i. e, a5 e+ m* T$ q: A
group by business_year
7 [" o7 N! g' C1 Y9 j1 N# Ounion all: `4 z3 d! A2 s& S: A$ l7 F
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
W/ Q7 h* l! r3 ~from admissions_data_info9 A* J& ~# y9 g# O+ k" K2 w( y! i
group by business_year
0 Q- p1 r0 S& x1 K)a
6 S6 {* P' W5 R) Ewhere area=:area
|3 b2 }& S# A& z4 J! V8 V0 `order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡