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 FROM retail.products WHERE on_markdown = 1

Question:

Now that you have the discount_pct, use your code from that calculation and multiply it by the original_price to see if it matches the discount_amount you calculated . Again, do this calculation in a new column and name the column check.

Hints:

For this new column, use the same code that you used for the last column, but multiply it by the original_price field.

Remember, you cannot reference a column name (like discount_amount) within the same query, so you will have to copy the calculation you used previously. Be careful of parentheses!