select * from (
- Y4 o, y3 G# j' \select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area ?% O _% `. n4 |* x% l
from admissions_data_info
- C* M7 j" T! Lgroup by business_year,area
$ s: B6 B4 Y) y k5 ?3 xunion all" O$ N2 C! Z* \4 U9 O. f' i* u( B
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
3 Z. t& ~0 H+ t+ W9 [, L# `, Q* Zfrom admissions_data_info) l p' p `' S
group by business_year,area
+ I3 I' Z8 e& J& ^: S* } Iunion all$ c( K: n4 n$ r' r9 C1 g# ?) B
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
+ T/ k: w0 `; _' s# L1 ^from admissions_data_info 5 E9 b0 W* e; W
group by business_year
! y' L8 O) \5 w P; A( Funion all
& C1 M3 D& c6 z; Zselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
1 C p2 j5 F6 M/ Y/ J" ^from admissions_data_info) \7 e4 a- ]; n4 k8 \2 X, d
group by business_year. D/ J7 F5 ^! ]7 h+ q' k
)a
! ]- r# E: \! |. S1 q! Owhere area=:area
0 z! P' w- O3 d6 q9 z* r2 D% Worder by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
