Lab 2 Student Answer Sheet\tLab 2, answer the questions and provide copies of your SQL Statements and\/or results for each Section listed below\tPart A: Employee List (4 points)\ta.What does Left function do? Is selecting the query and coping and could be pasted in a new query if is need it.\tb.Screen print your results and paste here:\tPart B: \u00a0Date Function (4 points)\u00a0\ta. How do you display the year part of a date?\tb. Paste your SQL Statement here:\tc. Screen print your results and paste here:\tPart C: \u00a0Using a Calculation in a Query (4 points)\ta. Paste your SQL Statement here\tScreen print your results and paste here:\tPart D: Practice SUM function (5 points)\ta. Paste your SQL Statement here:\u00a0\tb. Screen print your results and paste here:\tPart E: Practice Average, Maximum, and Minimum function (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart F: Practice function when value is NULL (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart G: \u00a0Using GROUP BY clause (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart H: Using function on WHERE clause (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart I: Using function to calculate date difference (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart J: Using conversion function (5 points) \ta. What do you use to convert the numerical data into VARCHAR data type?\tb. Paste your SQL Statement here:\tc. Screen print your results and paste here:\t\u00a0\tStudent Name:\tUsing Lab 3, answer the questions and provide copies of your SQL Statements and\/or results for each Section listed below\tPart A Join two tables (4 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart B: \u00a0Join two tables and apply WHERE clause (4 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart C: Inner join two tables (4 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart D: \u00a0Inner join two tables and apply WHERE clause – Practice # 1 (5 points)\tc. Paste your SQL Statement here:\td. Screen print your results and paste here:\tPart E: \u00a0Inner join two tables – Practice #2 (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart F: Inner join two tables – Practice #3 (5 points) \u00a0\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart G: Join two tables with sub-query – Practice # 1 (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart H: Join two tables with sub-query -Practice #2 (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:\tPart I: \u00a0Single table join (5 points)\tc. Paste your SQL Statement here:\td. Screen print your results and paste here:\tPart J: Complex join (5 points)\ta. Paste your SQL Statement here:\tb. Screen print your results and paste here:<\/p>\n","protected":false},"excerpt":{"rendered":"
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 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-203128","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=203128"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203128\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}