BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 27
a. Paste your SQL Statement here:
b. Screen print your results and paste here:
--------------------------------------------------------------------
BIS 345 Week 4 iLab
FOR MORE CLASSES VISIT
www.bis345mentor.com
Using Lab 4 provide copies of your SQL Statements and/or results for each
Section listed below
Part A Supplier and product list (10 points)
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: