【单选题】在商品表中统计提供的商品的总数量在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
【多选题】变压器的轻瓦斯保护动作于( ),重瓦斯保护动作于( )
【简答题】变压器重瓦斯保护应动作于( ),轻瓦斯保护应动作于( )。
【简答题】变压器的轻瓦斯保护动作于(),重瓦斯保护动作于()。
【简答题】在变压器瓦斯保护中,轻瓦斯保护动作于________,重瓦斯保护动作于________。
【单选题】在商品表中统计提供的商品的总数量在500到1000之间的供应商的编号,并显示提供的商品的总数量。
A.
select sum ( number ) 商品总数量 , supplierid 供应商编号 from shop group by supplierid having ( SUM ( number ))>= 500 or ( SUM ( number ))<=< span="">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