Part J: Using the“ LIKE” operator and the“%” wildcard( 6 points) =========================================================
BIS 345 Week 2 iLab FOR MORE CLASSES VISIT
www. bis345mentor. 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 Screen print your results and paste here: Part D: Practice SUM function( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part E: Practice Average, Maximum, and Minimum function( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part F: Practice function when value is NULL( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part G: Using GROUP BY clause( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part H: Using function on WHERE clause( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part I: Using function to calculate date difference( 5 points)