下面SQL语句都使用了聚合函数,其中选项()存在错误。
A:SELECT MIN(au_lname) FROM authors
B:SELECT ADD(ytd_sales+1) FROM titles
C:SELECT type,MAX(price) FROM titles GROUP BY type ORDER BY type
D:SELECT COUNT(*) ,avg(price) FROM titles WHERE advance > $1000
出自:计算机科学