Which statement best describes the purpose of a subquery in SQL$?$

Group of answer choices

To allow the insertion of new rows into a table based on values calculated from another table.

To execute a query within another query, allowing the results of the inner query to be used by the outer query.

To update records in one table based on conditions matched in another table without returning any results.

To execute the main query and then pass its result to the subquery for further processing.