Given the following table definition:
SALES
————————————–
INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON VARCHAR(25)
REGION CHAR(20)
SALES_AMT DECIMAL(9,2)
Which of the following queries will return SALES information, sorted by SALES_PERSON, from A
to Z, and SALES_DATE, from most recent to earliest?
A.
SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY
sales_person, sales_date DESC
B.
SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales SORT BY
sales_person DESC, sales_date
C.
SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY
sales_person, sales_date DESC
D.
SELECTinvoice_no, sales_person, sales_date, sales_amt FROM sales ORDER BY
sales_person DESC, sales_date