BIS 345 Week 4 iLab
For more course tutorials visit www. tutorialrank. com
Part B: Join two tables and apply WHERE clause( 4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: 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 course tutorials visit www. tutorialrank. 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)