Mass General Brigham Interview Question

What is a correlated subquery!