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 th a complete path between the tables with the data you need. . ere is 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 Query1, Query2, etc. I. Snow the OraeriR OTderpaie Freight for Orders witha 2. 5. Show the ProductName, and Total Quantity ordered. Sort by product name, descending (Z to A) and quantity ordered ascending (A to Z)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
