Previous equation:

SELECT product_id

, sku

, original_price

, current_price

, on_markdown

, original_price - current_price AS discount_amount

, ROUND(((original_price - current_price)/(original_price*1.00)),2) AS discount_pct

, ROUND((((original_price - current_price)/(original_price*1.00))*original_price),2) AS check

FROM retail.products

WHERE on_markdown = 1

Question:

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.

Hints:

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!