BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com

Part B: Customer List with only customers In France or Germany (4 points) Part C: Using a Calculation in a Query (5 points) Part D: Products that are discontinued (5 points) Part E: Practice using the BETWEEN operator (5 points) Part F: Practice using the “IN” operator (5 points) Part G: Understanding “NULL” (5 points) Part H: Using a composite condition (5 points) Part I: Using a “DATE” type variable and Concatenating Column Output (5 points) Part J: Using the “LIKE” operator and the “%” wildcard (6 points) ================================================== BIS 345 Week 2 iLab FOR MORE CLASSES VISIT www.bis345mentor.com a. b. c. a. Lab 2 Student Answer Sheet Lab 2, answer the questions and provide copies of your SQL Statements and/or results for each Section listed below Part A: Employee List (4 points) a.What does Left function do? Is selecting the query and coping and could be pasted in a new query if is need it. b.Screen print your results and paste here: Part B: Date Function (4 points) How do you display the year part of a date? Paste your SQL Statement here: Screen print your results and paste here: Part C: Using a Calculation in a Query (4 points) Paste your SQL Statement here Screen print your results and paste here: Part D:Practice SUM function (5 points)

BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Página 23