6. Write a SQL statement to find the details of a order i.e. order number, order date, amount of order, which customer gives the order and which salesman works for that customer and how much commission he gets for an order. Sample table: orders ord_no purch_amt ord_date customer id salesman_id 70001 70009 70002 70004 70007 70005 70008 70010 70003 70012 70011 70013 150.5 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 2012-09-10 3005 2012-07-27 3007 2012-09-10 3002 2012-10-10 3004 2012-10-10 3009 2012-06-27 3008 2012-08-17 3003 2012-04-25 3002 5002 5005 65.26 110.5 948.5 2400.6 5760 1983.43 2480.4 250.45 75.29 3045.6 5001 5003 5002 5001 5001 5006 5003 5002 5007 5001 Salesman city commissior salesman id name James Hoog New York 0.15 5002 5005 5006 5003 5007 Nail Knite Paris Pit Alex London Mc Lyon Lauson Hen Paul Adam Rome 0.13 0.11 0.14 0.12 0.13 Paris