BIS 345 Week 2 iLab For more course tutorials visit www. uophelp. com
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. uophelp. com
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?