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,

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 i:s 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 Answeir Create the query and close it to save it. Then it will name itself Queryl, so you will have Queryl, Query2, etc. 2. What is the average Freight paid for the orders? Hint: Use only a single field

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!