呼市小姐姐

duzhi

倡议绿色验证贴及赠送VIP方案，新老会员升级必看

select * from (
6 q4 a0 L" Q+ ^& V) ?select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
from admissions_data_info
group by business_year,area
union all
select business_year x,round(cast(sum(school_age_number)  as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
- B4 }$ D; _, K' L' s1 }& Ffrom admissions_data_info
9 Y% O9 h. N) d+ k3 \group by business_year,area
union all
, W: `9 I) A: J# ^1 T# N) P' _; Eselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
. N  d/ d+ X7 [, a+ `5 N$ b. Dfrom admissions_data_info
" [9 }6 _9 w+ \0 `/ i: B  Pgroup by business_year
' _1 P8 @0 M  nunion all
% @% p0 Z  T7 h1 @select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
from admissions_data_info
1 J# X( _8 ?8 K. |) {group by business_year
)a
3 v, @0 w  d7 D4 P& v; |# G8 Swhere area=:area
' Y/ B! b9 p9 n2 G7 Korder by x