select * from (8 l' Q: W( ^* |6 f; J
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
, y2 u/ k" w- Efrom admissions_data_info 2 z; I- U7 B9 c s
group by business_year,area; h# } U4 B" Y, C
union all
& N9 k( S N6 T. {' ~1 n. Mselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
' e: ~5 D) Q5 ofrom admissions_data_info
4 l6 g3 f. Z0 k( g2 Q) M/ s+ Hgroup by business_year,area. z/ J; q1 L0 N, ? o) u
union all
9 @1 B" _, f! W: Pselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area2 O6 v; z3 X/ k. C+ ^ ]! q: |
from admissions_data_info
( W2 P5 w U& h3 }# r, _group by business_year6 X5 ^7 r+ U. P/ ]: P
union all! f" U: P, _( k7 x- L
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
% k2 A9 T8 r9 E! }from admissions_data_info
1 N4 c: a* m/ W! H7 I' Sgroup by business_year
% H- o8 w/ Q# r3 r/ ]- J0 Q)a
4 Q) r6 N& n3 j( v1 c6 Bwhere area=:area) ]8 L2 N8 q( c' D% ~
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
显身卡