BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com | Page 24

a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
a.
b.
c.
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 VARC HAR
data type?
Paste your SQL Statement here:
Screen print your results and paste here:
==================================================
BIS 345 Week 3 iLab
FOR MORE CLASSES VISIT
www.bis345mentor.com
a.
b.
a.
b.
a.
Student Name:
Using Lab 3, answer the questions and provide copies of your SQL
Statements and/or results for each Section listed below
Part AJoin two tables (4 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part B: Join two tables and apply WHERE clause (4 points)
Paste your SQL Statement here:
Screen print your results and paste here:
Part C: Inner join two tables (4 points)
Paste your SQL Statement here: