BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 25

www.bis345mentor.com
a.
b.
c.
a.
a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
c.
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?
Paste your SQL Statement here:
Screen print your results and paste here:
Part C: Using a Calculation in a Query (4 points)
Paste your SQL Statement here
Screen print your results and paste here:
Part D:Practice SUM function (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part E: Practice Average, Maximum, and Minimum function (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part F:Practice function when value is NULL (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part G: Using GROUP BY clause (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part H: Using function on WHERE clause (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part I: Using function to calculate date difference (5 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part J:Using conversion function (5
points)
What do you use to convert the numerical data into VARCHAR data type?
Paste your SQL Statement here:
Screen print your results and paste here: