单项选择题
A.SELECT作者,AVG(单价)AS平均单价FROM图书WHEREYEAR(人库时间)≥=2000GROUPBY作者HAVING平均单价>30
B.SELECT作者,AVG(单价)AS平均单价FROM图书WHEREYEAR(人库时间)≥=2000GROUPBY作者HAVINGAVG(单价)≥30
C.SELECTAVG(单价)AS平均单价FROM图书WHEREYEAR(人库时间)>=2000GROUPBY作者HAVINGAVG(单价)≥30
D.SELECT作者,AVG(单价)AS平均单价FROM图书WHEREYEAR(人库时间)≥=2000ANDAVG(单价)>30GROUPBY作者