Which two SQL statements would executes successfully?

See the Exhibit and examine the structure and data in the INVOICE table:
Exhibit:

Which two SQL statements would executes successfully? (Choose two.)

See the Exhibit and examine the structure and data in the INVOICE table:
Exhibit:

Which two SQL statements would executes successfully? (Choose two.)

A.
SELECT MAX(inv_date), MIN(cust_id) FROM invoice;

B.
SELECT MAX(AVG(SYSDATE – inv_date)) FROM invoice;

C.
SELECT (AVG(inv_date) FROM invoice;

D.
SELECT AVG(inv_date – SYSDATE), AVG(inv_amt) FROM invoice;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Hola

Hola

Avg takes only numeric data type
Max can take anything