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:
Can You Do My Homework for Me?
YES, ⚡ Experience the brilliance of our essay writers from the US, UK, Canada, or Australia by entrusting us with your next essay.
Check before you submit. Get the Turnitin report your professor sees.
Get the exact same Turnitin report your professor uses. Join 50,000+ students who submitted their essays with confidence this semester.
NursingEssayHub.com is a distinguished ONLINE ESSAY WRITING AGENCY that specializes in offering expert writing help and assistance to students across all academic levels. With a team of highly skilled writers and editors boasting years of academic writing experience, we are fully equipped to guide you throughout the entire process, from selecting the perfect topic for your paper to completing a thorough literature review and delivering a well-formatted final draft.
ORDER A SIMILAR ESSAY WRITTEN FROM SCRATCH at : https://nursingessayhub.com/
