BIS 345 MENTOR Extraordinary Success /bis345mentor.com BIS 345 MENTOR Extraordinary Success /bis345mentor | Page 24

a. b. a. b. c. d. a. b. Part G: Join two tables with sub-query - Practice # 1 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part H: Join two tables with sub-query -Practice #2 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part I: Single table join (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part J: Complex join (5 points) Paste your SQL Statement here: Screen print your results and paste here: ===================================================== BIS 345 Week 4 iLab FOR MORE CLASSES VISIT www.bis345mentor.com Using Lab 4 provide copies of your SQL Statements and/or results for each Section listed below Part A Supplier and product list (10 points) a.Paste your SQL Statement here: b.Screen print your results and paste here: Part B: Order information (10 points) a.Paste your SQL Statement here: b.Screen print your results and paste here: Part C: Customer and order (10 points) a.Paste your SQL Statement here: a.Screen print your results and paste here: Part D: Employee and territory list (10 points) b.Paste your SQL Statement here: c.Screen print your results and paste here: Part E: Order and product (10 points) a.Paste your SQL Statement here: b.Screen print your results and paste here: Part F: Best customer list (10 points) a.Paste your SQL Statement here: b.Screen print your results and paste here: