7.Numeric Transformations.sql

use ecom;
-- NUMERIC TRANSFORMATIONS (Whenever we want to do mathematical operations)

select * from dim_product;
          
select
	unit_price * .90 as discounted_price,
    unit_price + 10 as taxed_price,
    unit_price / 10 as fractioned_price,
    round(unit_price,1) as rounded_price,
    unit_price * unit_price as multiplied_price  -- Can use different columns also
from
	dim_product;