Question: We have some basic data showing customers, the orders they placed, the line items in those orders and the products in each line item. Notes:

We have some basic data showing customers, the orders they placed, the line items in those orders and the products in each line item. Notes: Only use the tables you need to answer your query (question). You also must include any table in between too so that there is a complete path between the tables with the data you need. Strategy-Before you answer questions, check out the data-this helps you predict answers for your queries. Double Click on each table to see how many items there are in each table Queries (Questions) to Answer Create the query and close it to save it. Then it will name itself Queryl, so you will have Queryl, Query2, etc. OW ers 3. What shippers (ShipName) have shipped tofu? List their ShipName and full address. Sort by ShipName Ascending (A to Z) Hint: Duplicates are allowed. In fact, be sure you do NOT eliminate duplicates We have some basic data showing customers, the orders they placed, the line items in those orders and the products in each line item. Notes: Only use the tables you need to answer your query (question). You also must include any table in between too so that there is a complete path between the tables with the data you need. Strategy-Before you answer questions, check out the data-this helps you predict answers for your queries. Double Click on each table to see how many items there are in each table Queries (Questions) to Answer Create the query and close it to save it. Then it will name itself Queryl, so you will have Queryl, Query2, etc. OW ers 3. What shippers (ShipName) have shipped tofu? List their ShipName and full address. Sort by ShipName Ascending (A to Z) Hint: Duplicates are allowed. In fact, be sure you do NOT eliminate duplicates
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
