Describe a scenario where you would use a subquery instead of a join, and explain the performance implications of each.
