String Aggregation and Grouping

Medium
string-functions DoorDash Instacart Robinhood

Write a query to list each department with all employee names concatenated into a comma-separated string using GROUP_CONCAT. Return department and employees, ordered by department.

Expected Output: Departments with comma-separated employee lists.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...