Macquarie Group interview question

Database SQL about union of two tables as well as SQL Plans that get generated for various options.