{
    "action": "tool_call",
    "reasoning": "To determine the overall trend and check for seasonality, I will aggregate revenue and units sold by month using the order_date column.",
    "tool": "query_sql",
    "args": {
        "purpose": "Get monthly revenue and units sold to analyze the trend over time.",
        "source": "raw",
        "sql": "SELECT DATE_TRUNC('month', order_date) AS order_month, SUM(revenue_usd) AS total_revenue, SUM(units_sold) AS total_units FROM raw.global_sports_footwear_sales_2018_2026 GROUP BY 1 ORDER BY 1;"
    }
}