Generated SQL:
SELECT 
    COALESCE(c.company_name, CONCAT(c.first_name, ' ', c.last_name)) as customer_name,
    c.email,
    COUNT(so.id) as order_count,
    SUM(so.total_amount) as total_revenue,
    MAX(so.order_date) as last_order_date
FROM customers c
INNER JOIN sales_orders so ON c.id = so.customer_id
WHERE c.deleted_at IS NULL 
    AND so.deleted_at IS NULL 
    AND so.status NOT IN ('cancelled', 'draft')
    
GROUP BY c.id
ORDER BY total_revenue DESC
LIMIT 10;

✅ PASS: SQL matches SELECT pattern