How will a subquery be transformed by the normalizer?

A.
into a groupby

B.
into a join

C.
into an index scan

D.
into an MDAM range