考试科目：1Z0-082
考试题量：90
通过分数：60%
考试时间：150min
本文为云贝教育郭一军原创，请尊重知识产权，转发请注明出处，不接受任何抄袭、演绎和未经注明出处的转载。
https://www.yunbee.net/Home/News/detail/article_id/236.html
3. Examine the description of the products table
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
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.SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date
参考答案：D
解析：
AC不对，出现在group by 和select from 必须一致
B不对,多了MAX，如果在SELECT中用MAX，那么就要去掉：prod_id字段
create table products(
prod_id number not null,
prod_name varchar2(40),
cost number(8,2),
release_date date
);
