Evaluate this SELECT statement that includes a subquery: SELECT last_name, first_name, phone_num FROM prospect WHERE postal_code IN (SELECT postal_code FROM sales WHERE salesperson_id = 25); Which two statements are true about the given subquery? (Choose two.) The query on the prospect table executes before the query on the sales table. The results of the query on the sales table are returned to the query on the prospect table. The results of the query on the prospect table are returned to the query on the sales table. The query on the sales table executes once for the execution of the query on the prospect table. The query on the sales and the query on the prospect table must both return a value or an error occurs