BIS 345 Week 5 iLab For more course tutorials visit www. tutorialrank. com
As you prepare to create this query, decide which information needs to be displayed – this will be listed in the SELECT clause. Review the tables to determine which tables to use – these will be listed in the FROM clause. This problem will require a calculated field and an aggregate function. What fields will be in the GROUP BY? If more than one table is needed, how will these tables be joined? 1. Using the query window, type the SELECT statement needed to produce the desired results. The SQL is given below: 2. Press the Execute button. A partial result set is displayed below: 3. Answer the questions under Part B of your Lab Answer Sheet, and paste the first SELECT statement and a screenshot of the result set into a Microsoft Word document. Your SQL must be cut and pasted from your SQL window, and should NOT be a screenshot. However, you should use a screenshot of the result set as you did in the previous question. The screenshot should show at least the first 10 rows of the results. ===============================================
BIS 345 Week 5 iLab For more course tutorials visit www. tutorialrank. com
Using Lab 5, provide copies of your SQL Statements, results and reports for each Section listed below Part A Product 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)