Combining Query Results from Different Rows into One Using Oracle SQL with Common Table Expressions (CTEs) and Joins