Skip to content
SQLSimplified
hardlibraryaggregatestring_agggroup-by

Authors and Their Books

Problem

Return each author's name and a comma-separated list of their book titles (ordered by published_year), aliased books.

Try It

Library (Books/Authors/Publishers)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems