在商品表中统计提供的商品的总数量在500到1000之间的供应商的编号,并显示提供的商品的总数量。
A.
select sum ( number ) 商品总数量 , supplierid 供应商编号 from shop group by supplierid having ( SUM ( number ))>= 500 or ( SUM ( number ))<= 1000
B.
select sum ( number ) 商品总数量 , supplierid 供应商编号 from shop group by supplierid where number between 500 and 1000
C.
select count ( number ) 商品总数量 , supplierid 供应商编号 from shop group by supplierid having ( count ( number )) between 500 and 1000
D.
select sum ( number ) 商品总数量 , supplierid 供应商编号 from shop group by supplierid having ( SUM ( number )) between 500 and 1000