1 Write Select Statement Returns One Row Customer Order Show First Last Names Email Addres Q37178254

1. Write a SELECT statement that returns one row for eachcustomer that has order. Show:

1. The first and last names and email address of the customer
2. The sum of the item price in the multiplied by the quantity asa total price
3. The sum of the discount amount multiplied by the quantity asthe discount amount

Sort the result set in descending sequence by the item pricetotal for each customer.

2. List the count of the products order. Show the count and thename of the product

Answer