SELECT AGE,SUM(SL) from A表 left join B表 ON 关联字段A.1=B.1 GROUP BY AGE
(case when AGE <=30 then '30以下'
else '30以上' end) as 年龄段,sum(SL) as 数量
from a
group by (
case when AGE <=30 then '30以下'
else '30以上'
end)