```json { "queries": [ { "query": "SELECT deal_stage, COUNT(*) AS opportunities FROM b2b_sales_funnel_pipeline GROUP BY deal_stage ORDER BY opportunities DESC", "description": "Number of opportunities at each stage of the sales funnel." }, { "query": "SELECT sales_agent, COUNT(*) AS total_deals FROM b2b_sales_funnel_pipeline GROUP BY sales_agent ORDER BY total_deals DESC LIMIT 10", "description": "Top 10 sales agents by number of opportunities managed." }, { "query": "SELECT product, COUNT(*) AS deal_count FROM b2b_sales_funnel_pipeline GROUP BY product ORDER BY deal_count DESC", "description": "Most frequently pursued products across all opportunities." }, { "query": "SELECT account, COUNT(*) AS opportunities FROM b2b_sales_funnel_pipeline GROUP BY account ORDER BY opportunities DESC LIMIT 10", "description": "Top 10 accounts by number of sales opportunities." }, { "query": "SELECT sector, COUNT(*) AS account_count FROM accounts WHERE sector IS NOT NULL GROUP BY sector ORDER BY account_count DESC", "description": "Distribution of accounts across industry sectors." }, { "query": "SELECT office_location, COUNT(*) AS accounts FROM accounts WHERE office_location IS NOT NULL GROUP BY office_location ORDER BY accounts DESC", "description": "Number of accounts by office location." }, { "query": "SELECT product, series, sales_price FROM products ORDER BY sales_price DESC", "description": "All products with their series and sales prices, highest first." }, { "query": "SELECT manager, COUNT(*) AS team_size FROM sales_teams WHERE manager IS NOT NULL GROUP BY manager ORDER BY team_size DESC", "description": "Sales managers ranked by team size." }, { "query": "SELECT regional_office, COUNT(*) AS agents FROM sales_teams WHERE regional_office IS NOT NULL GROUP BY regional_office ORDER BY agents DESC", "description": "Number of sales agents per regional office." }, { "query": "SELECT a.sector, COUNT(DISTINCT b.opportunity_id) AS deals FROM accounts a JOIN b2b_sales_funnel_pipeline b ON a.account = b.account WHERE a.sector IS NOT NULL GROUP BY a.sector ORDER BY deals DESC", "description": "Sales opportunities by account sector, showing sector activity levels." } ] } ```