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:
Need Help Writing an Essay?
Our team of talented writers is ready to assist. We offer essay writing help in over 75 disciplines, ensuring a convenient and comprehensive solution for all your academic needs!
Get Help Now!Get Quick Assignment Writing Help – No Plagiarism Guarantee!
Online assignment writing service website that provide university students with original and quality academic essays, term papers, admission essays, annotated bibliographies, reports, scholarship essays, personal statements, research proposals, research papers, projects, presentations, dissertation, theses, movie reviews, Book reviews, application papers, among others.
Having trouble with a homework question? Our skilled assignment writers are here to provide answers to all types of queries, ranging from fundamental mathematics to cutting-edge rocket science!
