select * from (
& e A* C; q- Tselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area% {" ]; V9 g n- e$ C. x% a3 }, f
from admissions_data_info
/ i5 T2 I3 T/ h B6 pgroup by business_year,area( ^9 N# [! p$ @) L* Q6 \3 A: g7 k# n
union all
- p% u! p8 p+ qselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area- i% D6 _+ @+ w/ R* |
from admissions_data_info
& R( y0 X8 [" `# @% X. }) I' Pgroup by business_year,area/ q1 g6 ~9 p# q, y1 ?; E5 j
union all
. r" d& b7 b3 g* P& o6 u8 ?# lselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
: y0 n* C) d J. Y5 kfrom admissions_data_info 5 I+ x/ n: d w4 _
group by business_year0 p( @7 u6 W o0 A F& q
union all% a( x# s* E* z
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area: E2 Z: _' r7 E- k3 Z& C n
from admissions_data_info. q- ~: ]9 e8 C4 u: X/ w) D; ~
group by business_year, x7 N( V5 N% u$ ~ P
)a
& G0 [6 c7 F' n5 M6 qwhere area=:area1 \3 j* t& o* ?6 i; M
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜