These are two types of subquery – Correlated and Non-Correlated.

The correlated subquery cannot be considered as an independent query, but it can refer the column in a table listed in the FROM the list of the main query.

The Non-Correlated subquery can be considered as an independent query and the output of subquery are substituted in the main query.