```json { "queries": [ { "query": "SELECT deal_stage, COUNT(*) AS count FROM sales_pipeline GROUP BY deal_stage ORDER BY count DESC", "description": "Number of opportunities at each stage of the sales pipeline." }, { "query": "SELECT sales_agent, COUNT(*) AS opportunities, SUM(CAST(close_value AS DOUBLE)) AS total_value FROM sales_pipeline WHERE close_value IS NOT NULL GROUP BY sales_agent ORDER BY total_value DESC LIMIT 10", "description": "Top 10 sales agents by total deal value closed." }, { "query": "SELECT product, COUNT(*) AS deals FROM sales_pipeline GROUP BY product ORDER BY deals DESC", "description": "Most frequently sold products by number of deals." }, { "query": "SELECT sector, COUNT(DISTINCT account) AS accounts FROM accounts GROUP BY sector ORDER BY accounts DESC", "description": "Number of accounts in each business sector." }, { "query": "SELECT regional_office, COUNT(*) AS agents FROM sales_teams GROUP BY regional_office ORDER BY agents DESC", "description": "Sales team size by regional office location." }, { "query": "SELECT account, COUNT(*) AS opportunities FROM sales_pipeline GROUP BY account ORDER BY opportunities DESC LIMIT 15", "description": "Top 15 accounts by number of sales opportunities." }, { "query": "SELECT p.series, COUNT(*) AS deals FROM sales_pipeline sp JOIN products p ON sp.product = p.product GROUP BY p.series ORDER BY deals DESC", "description": "Sales volume by product series." }, { "query": "SELECT st.manager, COUNT(DISTINCT sp.sales_agent) AS team_size, COUNT(sp.opportunity_id) AS total_deals FROM sales_pipeline sp JOIN sales_teams st ON sp.sales_agent = st.sales_agent GROUP BY st.manager ORDER BY total_deals DESC", "description": "Manager performance by team size and total deals managed." }, { "query": "SELECT a.office_location, COUNT(sp.opportunity_id) AS deals FROM sales_pipeline sp JOIN accounts a ON sp.account = a.account GROUP BY a.office_location ORDER BY deals DESC LIMIT 10", "description": "Top 10 account office locations by sales activity." }, { "query": "SELECT deal_stage, AVG(CAST(close_value AS DOUBLE)) AS avg_value FROM sales_pipeline WHERE close_value IS NOT NULL GROUP BY deal_stage ORDER BY avg_value DESC", "description": "Average deal value at each pipeline stage." } ] } ```