第7题
The INVENTORY table contains these columns:
ID_NUMBER NUMBER PK
DESCRIPTION VARCHAR2(30)
SUPPLIER_ID NUMBER
PRICE NUMBER(7,2)
QUANTITY NUMBER
Evaluate this SQL statement:
SELECT d_number, description, SUM(price) FROM inventory WHERE price > 30.00 GROUP BY id_number ORDER BY supplier_id;
Why will this statement cause an error?
(A) The PRICE column must be included in the GROUP BY clause.
(B) The ORDER BY clause should immediately follow the WHERE clause.
(C) The SUPPLIER_ID column is NOT included in the SELECT clause.
(D) The DESCRIPTION and SUPPLIER_ID columns are NOT included in the GROUP BY clause.
为什么选D？谢谢了
分组函数啊，没有聚合函数的操作就要放在group by后面啊正确的应该是SELECT d_number, description,supplier_id， SUM(price) FROM inventory WHERE price > 30.00 GROUP BY id_number, description， supplier_idORDER BY supplier_id
