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.
This exercise is part of the course
Functions for Manipulating Data in PostgreSQL
Exercise instructions
- Convert the film category
name
to uppercase. - Convert the first letter of each word in the film's
title
to upper case. - Concatenate the converted category
name
and filmtitle
separated by a colon. - Convert the
description
column to lowercase.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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;