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 )