CommencerCommencer gratuitement

Transform numeric & strings

For this exercise you are planning to run a 50% off promotion for films released prior to 2006. To prepare for this promotion you will need to return the films that qualify for this promotion, to make these titles easier to read you will convert them all to lower case. You will also need to return both the original_rate and the sale_rate.

Cet exercice fait partie du cours

Applying SQL to Real-World Problems

Afficher le cours

Instructions

  • Return the LOWER-case titles of the films.
  • Return the original rental_rate and the 50% discounted sale_rate by multiplying rental_rate by 0.5.
  • Ensure only films prior to 2006 are considered for this promotion.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

SELECT ___ AS title, 
  ___ AS original_rate, 
  ___ * ___ AS sale_rate 
FROM film
-- Filter for films prior to 2006
___;
Modifier et exécuter le code