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

5 Ways to Make Integer Arrays in PostgreSQL Merge-joinable