107.View the Exhibit and examine the structure and data in the INVOICE table.

107.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
解析：
A:错误，avg函数的参数必须是数字类型，或者可以转成数字类型
B:正确
C:错误，AVG(SYSDATE - inv_date)这个本身是正确的，但是avg是聚合函数，而外层的max也是聚合函数，
这里就有问题了
D:正确