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)