-- 用户购买行为分析 SELECT u.id, u.name, COUNT(DISTINCT o.order_id) AS order_count, SUM(o.amount) AS total_spent, AVG(o.amount) AS avg_order_value, MIN(o.created_at) AS first_order,