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 ?