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.
Diese Übung ist Teil des Kurses
Applying SQL to Real-World Problems
Anleitung zur Übung
- 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.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
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 ___;