Using the Classic Model dataset, write the SQL that answers the following questi

Question

Using the Classic Model dataset, write the SQL that answers the following question. List the product name, product code, product line, and product line description for all products that are part of the Motorcycles product line. Using the Classic Model dataset, write the SQL that answers the following question. Report average payments for each customer. Order the list ascending by customer name. Output should include the average payment amount and customer name Using the classic Model dataset, write the SQL that answers the following question. List the value of shipped orders for each customer. The output should include the customer name, and total value of the order. Order the results by customer name. Using the Classic Model dataset, write the SQL that answers the following question. List the customer name, order number, and value of the order for customers that had orders with a value of less than $10,000. Order the results by value descending. Using the Classic Model dataset, write the SQL that answers the following question. List the product name, the customer name, the sales rep first name and last name, and the order number for all products shipped on a Tuesday. Order the results descending by the last name of the sales rep, followed by the first name, and then finally the customer name.

Explanation / Answer

select o.productName , c.customer_name ,o.salesRep_FirstName,o.salesRep_LastName , o.orderId from orders o inner join
customer c on c.custId = o.custId where o.shippedDay = 'Tuesday' order by o.salesRep_LastName, o.salesRep_FirstName,c.cutomerName desc

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.