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.)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
