复杂统计分析
课程：SQL · 编程练习
SQL编程练习 - 复杂统计分析
练习内容
-- 用户购买行为分析\nSELECT\n u.id,\n u.name,\n COUNT(DISTINCT o.order_id) AS order_count,\n SUM(o.amount) AS total_spent,\n AVG(o.amount) AS avg_order_value,\n MIN(o.created_at) AS first_or
课程：SQL · 编程练习
SQL编程练习 - 复杂统计分析
-- 用户购买行为分析\nSELECT\n u.id,\n u.name,\n COUNT(DISTINCT o.order_id) AS order_count,\n SUM(o.amount) AS total_spent,\n AVG(o.amount) AS avg_order_value,\n MIN(o.created_at) AS first_or