See the Exhibit and examine the structure and data in the INVOICE table:Exhibit:Which two SQL statements would executes
Posted: Wed Jun 07, 2023 6:12 am
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;
- See The Exhibit 1 (28.28 KiB) Viewed 148 times
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;