With an inner $($correlated$)$ subquery $...$

Question $10$ options:

The inner query executes for each row of the outer query.

The inner query evaluates only once, no matter how many rows are processed in the outer query.

The inner query can be executed independently from the outer query

The Inner query executes first and then the outer query