select
    [Industryname] as 行业名称,
    sum([allpile]) as 余额
FROM t_loanexpand
    where Industryname in('煤炭行业','焦炭行业','钢铁行业','电解行业','水泥行业','其他','所有行业') 
    group by [Industryname]
    order by charindex(Industryname,'其他所有行业')