Using Lab 5, provide copies of your SQL Statements, results and reports for each Section listed below Part AProduct and Category dataset( 7 points) a. Paste your SQL Statement here: Screen print your results and paste here: Part B: Product and Category report( 10 points) a. Paste your report here: Part C: Sales and Territory dataset( 10 points) a. Paste your SQL Statement here: Screen print your results and paste here: Part D: Sales and Territory, report( 10 points) a. Paste your report here: Part E: Sales and Territory Report Interpretation( 10 points) Write your interpretation of the results. The interpretation must be a minimum of one paragraph( 3 to 5 well-formed sentences) with no spelling or grammatical errors. Based on these results, what other data would you recommend that the business consider for further analysis? =========================================================
BIS 345 Week 6 iLab FOR MORE CLASSES VISIT
www. bis345mentor. com
Lab 6 Student Answer Sheet
Part A: Product Cost History dataset( 7 points) a. Paste your SQL Statement here b. Screen print your results and paste here: 1. CategoryList screenshot: 2. ProductList Screenshot
Part B: Product Cost History report( 10 points) a. Paste your report here: Report 1 – Screenshot: Part C: Yearly Sales by Category Dataset( 10 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part D: Yearly Sales by Category Chart( 10 points) a. Paste your report here: