View the Exhibit and examine the structure and data in the INVOICE table.
Which two SQL statements would execute successfully? (Choose two.)
Exhibit:
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 FunctionsYou 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.