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.
Essay Due Soon? Let Our Experts Help You Beat the Deadline!
Tell us about your assignment and we will find the best writer for your paper. Our Essay writing service covers over 243 courses and programs, catering to your specific needs.
Write My Essay For Me!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/
