Explain the performance differences between a JOIN and a subquery, and describe a scenario where you would choose one over the other.
