BIS 345 Week 2 iLab For more course tutorials visit www. tutorialrank. com
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 course tutorials visit www. tutorialrank. com
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) a. How do you display the year part of a date? b. Paste your SQL Statement here: c. Screen print your results and paste here: Part C: Using a Calculation in a Query( 4 points) a. Paste your SQL Statement here