Changing the case of string data
Now you are going to use the film and category tables to create a new field called film_category by concatenating the category name with the film's title. You will also format the result using functions you learned about in the video to transform the case of the fields you are selecting in the query; for example, the INITCAP() function which converts a string to title case.
Questo esercizio fa parte del corso
Functions for Manipulating Data in PostgreSQL
Istruzioni dell'esercizio
- Convert the film category
nameto uppercase. - Convert the first letter of each word in the film's
titleto upper case. - Concatenate the converted category
nameand filmtitleseparated by a colon. - Convert the
descriptioncolumn to lowercase.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT
-- Concatenate the category name to coverted to uppercase
-- to the film title converted to title case
___(___) || ': ' || ___(___) AS film_category,
-- Convert the description column to lowercase
___(___) AS description
FROM
film AS f
INNER JOIN film_category AS fc
ON f.film_id = fc.film_id
INNER JOIN category AS c
ON fc.category_id = c.category_id;