Examine the description of the products table
Name Null type
-----------------------------------------------------
PROD_ID NOT NULL NUMBER
PROD_NAME VARCHAR2(40)
COST NUMBER(8,2)
PRLEASE_DATE DATE
Which query is valid?
A.SELECT prod id, AVG(MAX (cost)) FROM products GROUP BY prod. B.SELECT prod id, MAX (AVG (cost)) FROM products GROUP BY prod id: C.Select prod id, release date, SUM(cost) FROM products GROUP BY prod id D.SELECT prod id, release date, SUM(cost) FROM products GROUP BY prod id, release date正确答案D
