Start on the Deals Sub-query

Once again, add it UNION ALL and copy/past the sub-query once again. You can, of course, create it from scratch, but this also serves to help you line up and include all the right columns.

The next topic covers how to JOIN tables to each other.