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.
Latihan ini adalah bagian dari kursus
Applying SQL to Real-World Problems
Petunjuk latihan
- Return the
LOWER-casetitles of the films. - Return the original
rental_rateand the 50% discountedsale_rateby multiplyingrental_rateby0.5. - Ensure only films prior to
2006are considered for this promotion.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT ___ AS title,
___ AS original_rate,
___ * ___ AS sale_rate
FROM film
-- Filter for films prior to 2006
___;