Question

查询一个商品有几个订单的SQL语句

Answer 1

select Name, count(Name) from SP group by Name
或者
select Name, sum(订单金额字段) from SP group by Name

Answer 2

select 商品名称 ,count(*) from table_name group by 商品名称