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 :