Intersect is incredibly useful for those who dislike using Excel to compare data sets. Quite simply, it will return rows from two matching selects that match.
If no match exists between the two, nothing will be returned. Perfect for use when you need to do list comparisons, especially where multiple columns exist.
SELECT offer_number FROM schema.table_1 INTERSECT SELECT offer_number FROM schema.table_2