CODE EXAMPLE FOR SQL

SQL Division Operator

-- returns new column named half_amount which is 
-- divided by 2 to the amount field
SELECT item, amount, amount/2 AS half_amount
FROM Orders;