1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • UPDATE the film table to increase the cost of renting (rental_rate) by 50 cents.
  • The rental_rate is shown in dollars.