Determine what the sale price would be for each item if the Marketing team went off the rails and implemented a sale for 35% off the original price of all items! Once again, add this new column onto the end of your existing query and name it discount_35. Want a hint?There are a couple different ways to get the right number for this last column. You can either multiply the necessary field by 0.65, which is 1 - 0.35. Or you can multiply the necessary field by 0.35 and subtract that from 1. Either way should work!
Determine what the sale price would be for each item if the Marketing team went off the rails and implemented a sale for 35% off the original price of all items! Once again, add this new column onto the end of your existing query and name it discount_35.
Want a hint?There are a couple different ways to get the right number for this last column.
You can either multiply the necessary field by 0.65, which is 1 - 0.35.
Or you can multiply the necessary field by 0.35 and subtract that from 1. Either way should work!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Determine what the sale price would be for each item if the Marketing team went off the rails and implemented a sale for 35% off the original price of all items!
Once again, add this new column onto the end of your existing query and name it discount_35.