Aggregating strings
You are planning to update your storefront window to demonstrate how family-friendly and multi-lingual your DVD collection is. To prepare for this you need to prepare a comma-separated list G-rated film titles by language released in 2010.
Cet exercice fait partie du cours
Applying SQL to Real-World Problems
Instructions
- Return a column with a list of comma-separated film
titles by using theSTRING_AGG()function. - Limit the results to films that have a
release_yearof2010ANDhave aratingof'G'. - Ensure that the operation is grouped by the language
name.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT name,
___ AS film_titles
FROM film AS f
INNER JOIN language AS l
ON f.language_id = l.language_id
WHERE ___
AND ___
GROUP BY ___;