How to Calculate Original Price After Discount | Bizfluent

Get original price from percentage discount

SOLVED: Calculate what percentage of the original price the discount amount is. Remember to add this calculation to the end of your query as another column and name it discountpct. Make sure that the result is less than 1 and contains 2 decimal places.Want a hint? Use the ROUND function to make sure your new column has only 2 decimal places. Refer back to the "Working with Decimals" portion of the "Math with SQL" lesson if you need a refresher on how to use the ROUND function.You will need to mu