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.
Este exercício faz parte do curso
Applying SQL to Real-World Problems
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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 ___;