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: Student Name: Using Lab 3, answer the questions and provide copies of your SQL Statements and/or results for each Section listed below Part A Join two tables (4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part B: Join two tables and apply WHERE clause (4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part C: Inner join two tables (4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part D: Inner join two tables and apply WHERE clause – Practice # 1 (5 points) c. Paste your SQL Statement here: d. Screen print your results and paste here: Part E: Inner join two tables – Practice #2 (5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part F: Inner join two tables – Practice #3 (5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part G: Join two tables with sub-query – Practice # 1 (5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part H: Join two tables with sub-query -Practice #2 (5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part I: Single table join (5 points) c. Paste your SQL Statement here: d. Screen print your results and paste here: Part J: Complex join (5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer