Update the UnitPrice for dairy products only by increasing i

Update the UnitPrice for dairy products only by increasing it by 4 percent. Run the query. Save the query as Update Prices. Close the query.

Solution

Hi friend, You have not given all details about Schema.

Based on details given in uestion, I am giving you a Update query :

UPDATE dairy_products
SET UnitPrice=(UnitPrice+0.04*UnitPrice)