Exercise

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.

Instructions

100 XP
  • Return a column with a list of comma-separated film titles by using the STRING_AGG() function.
  • Limit the results to films that have a release_year of 2010 AND have a rating of 'G'.
  • Ensure that the operation is grouped by the language name.