Basically just started using sql and having a minor problem. Working out the percentage of a number.
Example: What would I need to type in to work out:
2.75 - 5%
Drink_price= 2.75 After 5%discount = 2.61
So I need to deduct 5% of the price as a discount.
Sql doesn't seem to like the '%' key.