![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
有一个商品信息表(表名:ProInfo) ,表的字段为 ProID(商品编号) ,ProCatg(商品类 别) ,ProName(商品名称) ,ProPrice(商品价格) ,下列选项()可以查询每一类商品 的平均价格
A、Select ProCatg, AVG(ProPrice) From ProInfo
B、Select ProCatg, AVG(ProPrice) From ProInfo Group By ProCatg
C、Select AVG(ProPrice) From ProInfo Group By ProCatg
D、Select AVG(ProPrice) From ProInfo
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)