單項選擇題

下面SQL語句都使用了聚合函數(shù),其中選項()存在錯誤。

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

微信掃碼免費搜題