一、原题
二、题目翻译
三、题目解析
View the Exhibit and examine the structure and data in the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)
A. SELECT AVG(inv_date )
FROM invoice;
B. SELECT MAX(inv_date),MIN(cust_id)
FROM invoice;
C. SELECT MAX(AVG(SYSDATE - inv_date))
FROM invoice;
D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)
FROM invoice;
答案:BD
Which two SQL statements would execute successfully? (Choose two.)
A. SELECT AVG(inv_date )
FROM invoice;
B. SELECT MAX(inv_date),MIN(cust_id)
FROM invoice;
C. SELECT MAX(AVG(SYSDATE - inv_date))
FROM invoice;
D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)
FROM invoice;
答案:BD
二、题目翻译
下面是INVOICE表的结构和数据:
下面哪些SQL语句执行成功(选择2个)?
下面哪些SQL语句执行成功(选择2个)?
三、题目解析
A选项不正确,因为AVG的参数为数值类型或能隐式转换成数值类型的,在隐式转换inv_date时会报错。
C选项不正确,嵌套组函数需要使用group by子句。
C选项不正确,嵌套组函数需要使用group by子句。