See the Exhibit and examine the structure and data in the INVOICE table:
Which two SQL statements would execute successfully? (Choose two.)
A.
SELECT MAX(inv_date),MIN(cust_id)
FROM invoice;
B.
SELECT AVG(inv_date-SYSDATE),AVG(inv_amt)
FROM invoice;
C.
SELECT MAX(AVG(SYSDATE-inv_date))
FROM invoice;
D.
SELECT AVG(inv_date)
FROM invoice;
C is wrong, its needs group by function.
D is wrong date datatype is not avg.
SELECT MAX(AVG(SYSDATE-inv_date))
FROM invoice;
ORA-00978: nested group function without GROUP BY
Also AVG expects Number not date.
select avg(hire_date) from employees
ORA-00932: inconsistent datatypes: expected NUMBER got DATE