Explain correlated subqueries and provide an example use case

Question Explain

This question assesses understanding of dependent subqueries and their execution behavior.