CODE EXAMPLE FOR SQL

SQL Multiplication Operator

-- returns new column named total_amount  which is 
-- 4 multiplied to the amount field
SELECT item, amount, amount*4 AS total_amount
FROM Orders;