analyze_subqueries