Which two SQL statements would execute successfully?

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

Exhibit:Which two SQL statements would execute successfully? (Choose two.)

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

Exhibit: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;



Leave a Reply 0

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

14 + 7 =