Using SQL and UNION ALL to Aggregate Data from Multiple Columns

How to Create a Pivot Table in Oracle SQL Without Using Aggregate Functions

Efficiently Unpivoting Multiple Columns into Name and Value Pairs in SQL