microsoft SQL Server Management Studio Write a SELECT statement that returns one

Question

microsoft SQL Server Management Studio

Write a SELECT statement that returns one row for each customer that has orders with these columns: The Email Address column from the Customers table A count of the number of orders The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.) Return only those row's where the customer has more than than 1 order. Sort the result set in descending sequence by the sum of the line item amounts. Write a SELECT statement that answers this question: Which customers have ordered more than one product? Return these columns: The email address from the Customers table The count of distinct products from the customers orders

Explanation / Answer

SELECT DISTINT EMAILADDRESS,NO_OF_ORDERS, ((PRICE-DISCOUNT)*QUANTITY) AS TOTAL_AMOUNT WHERE NO_OF_ORDER>1 ORDER BY TOTAL_AMOUNT

3) SELECT EMAILADDRESS,COUNT(PRODUCTS) FROM CUSTOMERS_TABLE JOIN ON CUSTOMERS_ORDERS WHERE CUSTOMERS_TABLE.CUSTOMER_NO=CUSTOMERS_ORDER

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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