select sum(t1.销量) as T
-- ,t1.销售员
,t1.地区
,t1.产品类型
from 销量 t1
where 1=1
and t1.地区 = '${地区}'
group by
-- t1.销售员
t1.地区
————————————————————————————