SELECT 库龄,count(库龄) AS SL FROM TABLE GROUP BY 库龄
select
sum(case when 库龄='大于一年' then 1 else 0 end) as 大于一年,
sum(case when 库龄='小于一年' then 1 else 0 end) as 小于一年
from 表