Explain the difference between using an INNER JOIN and an INTERSECT operator, and describe when you would use each.
