IS there a way in SQL to make multiple rows for a common column, show up in one?

For example I would like this output:

to show up as:

CodePudding user response：

I believe this article contains solutions to your question -

SQL Query to concatenate column values from multiple rows in Oracle