Type of subquery

Correlated Subquery.
Non-correlated Subquery.

A subquery is either correlated or non correlated.