用order by case when给三个列排优先级顺序

select *
from report_premium_fen2
where 1=1 and zoneflag = ‘year’ and code =’4408 ’ and report_date=’2018-01-22’
order by
case when kindkind1=’合计’ then ‘0’ when kindkind1=’车险’ then ‘1’ when kindkind1=’商非合计’ then ‘2’ else kindkind1 end ,
case when kindkind2=’合计’ then ‘0’ when kindkind2=’车险’ then ‘1’ when kindkind1=’商非合计’ then ‘2’ else kindkind2 end ,
case when kindkind3=’合计’ then ‘0’ when kindkind3=’车险’ then ‘1’ when kindkind1=’商非合计’ then ‘2’ else kindkind3 end

若泽大数据交流群：671914634