BIS 345 mentor Career Begins/bis 345mart.com BIS 345 mentor Career Begins/bis 345mart.com | Page 27

Part C: Inner join two tables( 4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part D: Inner join two tables and apply WHERE clause- Practice # 1( 5 points) c. Paste your SQL Statement here: d. Screen print your results and paste here:
Part E: Inner join two tables- Practice # 2( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part F: Inner join two tables- Practice # 3( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part G: Join two tables with sub-query- Practice # 1( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part H: Join two tables with sub-query-Practice # 2( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part I: Single table join( 5 points) c. Paste your SQL Statement here: d. Screen print your results and paste here:
Part J: Complex join( 5 points) a. Paste your SQL Statement here: b. 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)