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 )