Left Joining Twice on the Same Table with Multiple IDs Using SQL and Common Table Expressions (CTEs)