Joining Tables Based on Shared Numerical Portion Without Joins or Unions

Using Grouping Sets to Reference Values in First Selects from Second Selects within Unions in PostgreSQL