SELECT name, cost, cost-1 AS discount_price FROM items       

SELECT + MATH ➔ Allows you to create a new column called discount_price that has all the values in cost but with 1 subtracted.