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