Which two SQL statements would execute successfully?

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;

Explanation:
Using the AVG and SUM Functions
You can use the AVG, SUM, MIN, and MAX functions against the columns that can store numeric data. The
example in the slide displays the average, highest, lowest, and sum of monthly salaries for all sales
representatives
Using the MIN and MAX Functions
You can use the MAX and MIN functions for numeric, character, and date data types. The example in the slide
displays the most junior and most senior employees.