![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
现有书目表book,包含字段:价格price(float),类别type(char);现在查询各个类别的平均价格、类别名称,以下语句正确的是()
A.selectavg(price),typefrombookgroupbytype
B.selectcount(price),typefrombookgroupbyprice
C.selectavg(price),typefrombookgroupbyprice
D.selectcount(price),typefrombookgroupbytype
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_ckda.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_wyda.png)
- · 有5位网友选择 A,占比45.45%
- · 有4位网友选择 B,占比36.36%
- · 有1位网友选择 D,占比9.09%
- · 有1位网友选择 C,占比9.09%