For each sale made on June 1, 2015, show the following information: CustomerID, Customer name (lastname + comma + space + firstname) as 'CustomerName', SaleDate, Sum of Tax and Shipping as 'tax_shipping'. Sort it by customer last name.
1. For each sale made on June 1, 2015, show the following information: CustomerID, Customer name (lastname + comma + space + firstname) as 'CustomerName', SaleDate, Sum of Tax and Shipping as 'tax_shipping'. Sort it by customer last name.
2. For each sale made on June 1, 2015, show the following information: CustomerID, Customer name (lastname + comma + space + firstname) as 'CustomerName', SaleDate, ProductName, ItemSize, Quantity and the total amount of each sale item (quantity times SalePrice as 'SaleAmount'). Sort it by customer last name. Hint: The answer result will have a record for each SaleItem.
3. The color field in the Product table has a mix of single colors or multiple colors separated by commas. Provide a list of Products and replace every comma with a semicolon plus one space. Name the column 'OpenColor'. Show ProductID, ProductName, Composition, Category, and 'OpenColor'. For simplicity include only ProductIDs for products with a list price of less than $20 and whose length of the color data is greater than 7 characters. (This eliminates many records we don't need to observe.)
![](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd2794d59-8b44-4eb1-924f-9f6c87099216%2F81eaf466-6de7-44ee-9c2e-5c070ec3b51f%2F47nine.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)