-- returns new column named total_amount which is -- 100 added to the amount field SELECT item, amount, amount+100 AS total_amount FROM Orders;