What is the standard execution rule for subqueries?

A. The result form the outer SELECT statement are provided as input to the inner SELECTstatement.

B. The result form the outer SELECT statement are provided as input to the outer SELECTstatement.

C.The SELECT statement ion the main query and subquery are ran at same time.

D.The SELECT statement in the main query and subquery are run in term of relative data analyzed.