How to Perform Inner Joins Based on a Condition in SQL with Grouping and Union