Order Details
Final State
Initial State
Start 3.1.yxdb
Start 3.1.yxdb
Practice Exercise 3
Combine the customer information from the last exercise with "Order Details" to find the Total and Total Saved for each order.
Combine the customer information in "Start 3.1" with the "Order Details". Ensure both the "Order Date" and "Ship Date" columns are formatted as "date" datatype.
Find the number of days to ship after the order was placed for each line item. Also calculate the subtotal for each line item (discount and shipping are flat costs, not per quantity). Finally, find the Total cost for each order, the "Total Saved" for each order, and the minimum days to ship any line item within each order.
Order Details.yxdb
Order Details.yxdb
Final State - Exercise 3.yxdb
Final State - Exercise 3.yxdb
Ship Date
English
MM/dd/yyyy
Ship Date_OK
Convert Ship Date From:
MM/dd/yyyy
Total Cost = [Unit_Price]*[Quantity_ordered_new]+[Shipping_Cost]-[Discount]
Days...
Horizontal
Practice Exercise 3