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 )