JOINS - Grouping
42.6
Exercise

JOINs with GROUP BY - 5

Write an SQL query to display the name of all unique courses, and a list of all books that belong to that course, all separated by a comma followed by a space (‘, ‘).

Set the headers for name of courses, and list of books as course and books respectively.

Note: Skip courses that do not have any book that belongs to them.