!!!! E | Challenge #1 - Part 5 Task Determine what the sale price would be...

Transcribed Image Text:

!!!! E | Challenge #1 - Part 5 Task 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! Not quite. Edit your query and try again! * 2 query.sql 1 select p.*, p.original_price*0.35-1 as discount_35 from retail.products p; product_id sku CT- BLK- 8 1 SQL Viewer 2 sq1101 D CT- BLK- 8.5 X CT- + + product_type Cap Toe Cap Toe color size full_name category materia black 8.0 black 8.5 Cap Toe - Black - 8 Cap Toe - Black - 8.5 Cap Toe - men men leather leather Run san A-Z O bongo !!!! E | Challenge #1 - Part 5 Task 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! Not quite. Edit your query and try again! * 2 query.sql 1 select p.*, p.original_price*0.35-1 as discount_35 from retail.products p; product_id sku CT- BLK- 8 1 SQL Viewer 2 sq1101 D CT- BLK- 8.5 X CT- + + product_type Cap Toe Cap Toe color size full_name category materia black 8.0 black 8.5 Cap Toe - Black - 8 Cap Toe - Black - 8.5 Cap Toe - men men leather leather Run san A-Z O bongo