SELECT title, price / 2 AS "half price"
SELECT title, ROUND(price + (price * 0.1),2) AS "Price with GST"
SELECT title, calories - 200 AS "Calories with low-carb cheese"
WHERE description LIKE "%cheese%"
- Everything is $5 off! work out a list of the new prices.
- Challenge - work out the next available number in the num field (for example, incase i wanted to add a new menu item - what would be the next available number? your query should display the result 14, given that there are currently 13 items)