With Common Table Expressions you can process the shared data in one set ("temporary table" is a good mental model for it), compute the unique parts in subseque

With Common Table Expressions you can process the shared data in one set ("temporary table" is a good mental model for it), compute the unique parts in subsequent sets and use the results for the UNION in a single query.