Question: Display order number, order date, status, and customer number for all orders that are cancelled from July to the end of October 16. Sort the
Display order number, order date, status, and customer number for all orders that are cancelled from July to the end of October 16. Sort the result according to order date.
please help me with the sql
Solt.. 1 2 3 4 SALESMAN_ID ORDER_DATE 5417-NOV-16 55 20-FEB-17 55 03-JAN-17 56 15-OCT-17 56 09-APR-17 57 15-AUG-17 57 01-DEC-16 59 09-APR-15 5 6 7 87 8 9 59 11-MAY-17 10 60 03-DEC-16 11 61 20-DEC-16 12 62 16-AUG-16 62 02-MAY-15 13 14 15 62 29-SEP-16 62 13-DEC-16 62 02-DEC-16 16 17 62 27-OCT-16 18 62 27-OCT-17 19 Plicer ORDER_ID CUSTOMER_ID STATUS 105 1 Pending 44 2 Pending 101 3 Pending 1 4 Pending 5 5 Canceled 28 6 Canceled 7 Canceled 4 8 Shipped 41 9 Shipped 82 44 Shipped 102 45 Shipped 26 46 Shipped 43 47 Shipped 53 48 Shipped 81 49 Shipped 83 16 Shipped 93 17 Shipped 94 1 Shipped 79 2 Shipped 80 3 Shipped 2 4 Shipped 3 5 Shipped 6 6 Shipped 7 7 Shipped 8 8 Shipped 9 9 Shipped 10 44 Pending 11 45 Shipped 12 46 Shipped 13 47 Shipped 14 48 Shipped 15 49 Shipped 16 16 Pending 17 17 Shipped 18 18 Shipped 19 19 Shipped 20 20 Shipped 21 21 Pending 22 22 Canceled 6414-DEC-16 20 21 22 23 24 25 26 27 28 1 29 30 6413-DEC-16 (null) 26-APR-15 (null) 26-APR-17 (null) 09-APR-15 (null) 15-FEB-17 (null) 14-FEB-17 (null) 14-FEB-17 (null) 24-JAN-17 (null) 29-NOV-16 (null) 29-NOV-16 (null) 29-NOV-16 (null) 28-SEP-17 (null) 27-SEP-17 (null) 27-SEP-16 (null) 27-SEP-17 (null) 16-AUG-16 (null) 27-MAY-16 (null) 27-MAY-17 (null) 27-MAY-17 (null) 26-MAY-16 null 07-SFD-16 31 32 33 34 35 36 37 38 39 4n 23 72 Chinnad
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
