4.1 Using the Sales Rep database write SQL select statements to: 4.1. a) Find details on sales reps from the state of Michigan (abbrev MI) who have total com- mission greater than 2000 (Jones, Smith, Brown). 5 marks 4.1. b) Find the description of Parts without duplicates that have been ordered. 5 marks 4.1. c) Find names of customers who have ordered part BT04 and have a current balance less than 300 (Don Charles has bal = 200). 5 marks 4.1. d) Find sales rep data for sales rep that have more than 2 customers assigned to them. (data for reps Smith, Brown) 5 marks 256 315 Order line Order inx Ord_No Part_No Qty_Ord Q_Price 12489 AX12 11 14.95 Ord_No Ord_Date Cust_No 12491 BT04 1 402.99 12489 2002-02-09 124 12491 BZ66 1 311.95 12491 2002-02-09311 12494 CB03 175.00 12494 2002-04-09 315 12495 CX11 57.95 12495 2002-04-09 256 12498 AZ52 22.95 12498 2002-05-09 522 12498 BA74 4 4.95 12500 2002-05-09 124 12500 BT04 1 402.99 12504 2002-05-09 522 12504 C2812 108.99 Customer Cust_No Cust_Name Cust_Addr Curr_Bal Credit Rep_No 124 Sally Adams 481 Oak. Lansina. MI 4 18.75 500 3 Ann Samuels 215 Pete. Grant. MI 1 0.75 800 6 311 Don Charles 48 Colleae. Ira. MI 200.10 300 12 Tom Daniels 914. Cherrv. Kent. MI320.75 3006 405 Al Williams 519 Watson. Grant. MI 201.75 800 12 Sally Adams 16 Elm. Lansing.MI 908.7510003 Marv Nelson 108 Pine. Ada, MI 49.50 800 12 Joe Baker 808 Ridae. Harper. MI 201.20 300 NULL 587 Judy Roberts 512 Pine. Ada. MI 5 7.75 500 6 622 NULL Dan Martin 419 Chio. Grant. MI 575.50 500 Part Part_No Description Units_Avaid WHOUSE U_Price AX 12 Iron HW 3 17.95 AZ52 Skates 20 2 24.95 BA74 Baseball 40 4.95 BH22 Toaster 34.95 BT04 Stove 402.99 BZ66 Washer 311.95 CA14 Skillet 19.95 Bike 44 187.50 CX11 Mixer 112 57.95 CZ81 Weichts 208 Slsrep Rep_No Rep_Name Rep_Addr Tot_Comm Comm_Rate Joe Blogas 1 Rossa Avenue. Cork. Ire 0.00 0.00 Marv Jones 123 Main. Grant. MI 2150.00 0.05 William Smith 102 Raymond. Ada. MI 4792.50 0.07 12 Sam Brown 419 Harper. Lansina. MI 2150.00 0.05 115 WA 567 104 MNM CB03 2 108.99