sql statements

SLSR SLR SLSR LAST FIRST STREET SALES REP SESR SLSR SESR Z SLSR SLSR CITY STATELIP TOTAL COMM CODE COMMISSION ISSION RATE SLSR SALES REP NUMBER (PK) 103 106 12 2150.00 OS Jonica Mary 123 Main Grant MI Smith William 102 Raymond Ada MI Diar Miguel 419 Harper Lansing MI 49141 19224 4912.50 2150,00 07 OS IMIT CUSTOMER CUST CUST CUST FI CUST CUSTCU CUST CUST CUST CUST CUSTOMER LAST RST STREET CITY ST ZIP BALANC CREDIT L SALES NUMBER STAT CODE REP PK) JE NUM BER 1124 Adams Sally 1481 Oak Lansing MI 149224 818.75 1000 03 239 Yours) Yours) 239 Drive Edison MI OSIS 1000.00 3000 12 256 Samuels Ann 215 Pele Grant MI 49219 21.50 OS 311 Charles Don 18 College la MI 09034 825.75 1000 12 BIS Daniel Tom 1914 Cherry Ken IMI 46391 7775 750 1405 Williams 519 Watson Grant MI 19219 402.75 1500 12 412 Adams Sally 16 Em Lansing MI 49224 1817.50 2000 03 527 Nelson Mary 108 Pins MI 49441 08.75 1500 12 567 Dinah Tiran 808 Ridge Harper MI 48421 402.40 750 06 SK7 Calvin Mara $12 Pune Ada MI 49441 114.60 1000 os 1622 Martins Dan 419 Chipirant MI 19219 1045.751 1000 03 SE Ada PART PART PART PART PART PART PART PART NUMBER PART DESCRIPTION UNITS ON ITEM WAREHOUSE UNIT PRICE PK) HAND CLASS NUMBER AXT2 ro 104 HW 3 24.95 JAZS2 Dartboard 20 SG 12.95 BA74 Basketball 40 SG 29.95 IBH Corn Popper 95 HW 34.95 BT04 Gas Grill 11 AP 2 149.99 B766 Washer 52 AP 13 399 00 CA14 Griddic 178 HW B 3990 Bike 44 SG 11 299.99 CXII Blender 112 HW 3 220 CZNI Treadmill 108 SG 12 349.95 ORDERS ORDR ORDR ORDR ORDER_NUMBER ORDER DATE CUSTOMER NUMBER (PK) 1 249 09/02/2018 124 12491 09/02/2018 311 12494 09.04.2018 315 12495 109/2018 1256 12498 09/05/2018 12500 09/05/2018 124 112504 09/05/2018 $22 12507 109 22/2018 219 ORDERS ORDR ORDR ORDR ORDER NUMBER ORDER DATE CUSTOMER_NUMBER (PK) 12489 09/02/2018 124 12491 09/02/2018 311 12494 109/04/2018 315 12495 09/04/2018 256 12498 09/05/2018 522 12500 09/05/2018 124 12504 09/05/2018 522 12507 09/22/2018 239 ORDER LINE ORLN JORLN ORLN ORLN ORDER NUMBER (PK) PART_NUMBER (PK) NUMBER_ORDERED QUOTED PRICE 12489 AXI2 11 21.95 12491 BT04 1 149.99 12491 BZ66 1 399.99 12494 CB03 14 279.99 12495 CX11 2 22.95 12498 AZ52 2 12.95 12498 BA74 14 24.95 12500 BT04 1 149.99 12504 CZ81 325.99 12507 CB03 299.99 s. Repeat the prior Exercise, but this time order the rows by item class and then by order number. 6. Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000. 7. Find the customer number, last name, and first name for every customer for very customer who currently has an order on file for an iron. 8. List the part description, part number, order number and order date for every order placed by Mary Nelson that contains an order line for a treadmill. 9 List the part description, part number, order number and order date for every order placed by Mary Nelson that does not contain an order line for a treadmill