BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 26

-------------------------------------------------------------------- BIS 345 Week 3 iLab FOR MORE CLASSES VISIT www.bis345mentor.com a. b. a. b. a. b. c. d. a. b. a. b. a. b. a. b. c. d. Student Name: Using Lab 3, answer the questions and provide copies of your SQL Statements and/or results for each Section listed below Part AJoin two tables (4 points) Paste your SQL Statement here: Screen print your results and paste here: Part B: Join two tables and apply WHERE clause (4 points) Paste your SQL Statement here: Screen print your results and paste here: Part C: Inner join two tables (4 points) Paste your SQL Statement here: Screen print your results and paste here: Part D: Inner join two tables and apply WHERE clause - Practice # 1 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part E: Inner join two tables - Practice #2 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part F:Inner join two tables - Practice #3 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part G: Join two tables with sub-query - Practice # 1 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part H: Join two tables with sub-query -Practice #2 (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part I: Single table join (5 points) Paste your SQL Statement here: Screen print your results and paste here: Part J: Complex join (5 points)