Given certain specifications, create a SELECT statement that correctly sorts the information in a table.
Create a
SELECT
statement for the following table, named Orders:
OrderNum | ItemNum | Date | Qty | CustID |
4332 | 1001 | 12/31/97 | 5 | 0001 |
4321 | 1001 | 01/10/98 | 1 | 1231 |
4332 | 1002 | 12/31/97 | 1 | 0001 |
4333 | 1003 | 01/15/98 | 1 | 0002 |
4321 | 1010 | 01/10/98 | 10 | 1231 |
4334 | 1011 | 01/10/98 | 1 | 1231 |
4335 | 1231 | 01/15/98 | 1 | 4325 |
4335 | 1001 | 01/15/98 | 1 | 4325 |