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)
a. Paste your SQL Statement here:
b. Screen print your results and paste here:
Part J: Using conversion function (5 points)
a. What do you use to convert the numerical data into VARCHAR data type?
b. Paste your SQL Statement here:
c. Screen print your results and paste here:
From essays to dissertations, we deliver on time, every time.
DO MY ASSIGNMENTS!We are a reliable online essay writing website that offers tailor-made assignment answers for students. From essays to dissertations, we deliver on time, every time. We specialize in helping university students to turn in the best possible essays. We offer a full range of services aimed at delivering high quality papers and we do it all at affordable rates. If you are looking for essay writing services we can help you.
Ask for Instant Assignment Writing Help. No Plagiarism Guarantee!
