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.
Latihan ini adalah bagian dari kursus
Functions for Manipulating Data in PostgreSQL
Petunjuk latihan
- 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.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
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;