Chapter 5 Exercise 17

Make a backup copy of the database before attempting this exercise.

17. Write a query to increase the list price of Dog merchandise by 5 percent.

First test it:
SELECT Round(ListPrice*1.05,2)
FROM Merchandise
WHERE Category="Dog";
 
>> you probably do not want to run this query because it will change the list prices
UPDATE Merchandise
SET ListPrice = Round(ListPrice*1.05,2)
WHERE Category="Dog";