BIS 345 Course Great Wisdom / tutorialrank.com BIS 345 Course Great Wisdom / tutorialrank.com | Page 21

a. Paste your SQL Statement here: b. Screen print your results and paste here: Part B: Order information( 10 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part C: Customer and order( 10 points) a. Paste your SQL Statement here: a. Screen print your results and paste here: Part D: Employee and territory list( 10 points) b. Paste your SQL Statement here: c. Screen print your results and paste here: Part E: Order and product( 10 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part F: Best customer list( 10 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part G: Join Shipper list( 10 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part H: Account payable( 10 points) a. Paste your SQL Statement here: a. Screen print your results and paste here Part I: Create a dataset for reporting( 10 points) b. Paste your SQL Statement here: c. Screen print your results and paste here: Part J: Report( 10 points) a. Paste a screen print of the report view: Lab 4 Part 1: Table Joins and functions Overview Using the Northwind database, you have been requested to select data for specific needs. Once selected, your data will be presented to management. You will have to determine which fields are the most appropriate to be selected. Do not include any fields that management does not need to see. Below is a screenshot of the Northwind Database schema: