Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 10.35. - Or you can multiply the necessary field by and subtract that from 1 . Either way should work! Run a SQL query to generate results
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started