Correlating Subqueries with Outer Queries: A Deep Dive into EXISTS and IN Clauses