-- 创建用户订单汇总视图 CREATE VIEW user_order_summary AS SELECT u.id, u.name, u.email, COUNT(o.order_id) AS total_orders, COALESCE(SUM(o.amount), 0) AS total_amount, MAX(o.created_at) A
-- 创建用户订单汇总视图 CREATE VIEW user_order_summary AS SELECT u.id, u.name, u.email, COUNT(o.order_id) AS total_orders, COALESCE(SUM(o.amount), 0) AS total_amount, MAX(o.created_at) A