select Name, count(Name) from SP group by Name或者 select Name, sum(订单金额字段) from SP group by Name
select 商品名称 ,count(*) from table_name group by 商品名称
