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...