{
    "action": "tool_call",
    "reasoning": "I will query the yearly revenue, units, and orders to provide a high-level summary of the trend before diving into the quarterly and monthly spikes and dips.",
    "tool": "query_sql",
    "args": {
        "purpose": "yearly trend",
        "source": "raw",
        "sql": "SELECT date_trunc('year', order_date) as order_year, SUM(revenue_usd) as total_revenue, SUM(units_sold) as total_units, COUNT(order_id) as total_orders FROM raw.global_sports_footwear_sales_2018_2026 GROUP BY 1 ORDER BY 1"
    }
}