Update the price of rentals
You just learned that there have been some updates for the rental pricing of your films.
In this exercise you will leverage the UPDATE
command to modify the rental prices by increasing the rental_rate
with the following logic.
- All films now cost 50 cents more to rent.
- R Rated films will go up by an additional 1 dollar.
This exercise is part of the course
Applying SQL to Real-World Problems
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Increase rental_rate by 0.5 in the film table
UPDATE ___
SET ___ = ___;