This video demonstrates how to use Correlated Subqueries in the real world scenario and also explains how they work. The Correlated Subqueries are always running the INNER query for every row that is processed in the OUTER Query. In Simple words, the INNER query runs as many times as there are total number of number of rows in the table.
~ Outer Query
~ Inner Query
~ Run multiple times.