select count(1) 总数
,sum(case when 座位数 between 0 and 5 then 1 else 0 end ) 0~5
,sum(case when 座位数 between 6 and 10 then 1 else 0 end ) 6~10
,sum(case when 座位数 >10 then 1 else 0 end ) 11以上
from table_name
where 车类='客'
and 状态 in ('正常','报停')
,sum(case when 座位数 between 0 and 5 then 1 else 0 end ) 0~5
,sum(case when 座位数 between 6 and 10 then 1 else 0 end ) 6~10
,sum(case when 座位数 >10 then 1 else 0 end ) 11以上
from table_name
where 车类='客'
and 状态 in ('正常','报停')
8i的话就要用decode函数+sign函数来实现