String Aggregation and Joining Through Association Table in PostgreSQL

Concatenating Rows into One Cell and Adding Break Line after Each Row using SQL Server

How to Transform Data from Long Format to Short Format Using Oracle's SQL Pivoting Technique