创建视图
课程：SQL · 编程练习
SQL编程练习 - 创建视图
练习内容
-- 创建用户订单汇总视图\nCREATE VIEW user_order_summary AS\nSELECT\n u.id,\n u.name,\n u.email,\n COUNT(o.order_id) AS total_orders,\n COALESCE(SUM(o.amount), 0) AS total_amount,\n MAX(o.creat
课程：SQL · 编程练习
SQL编程练习 - 创建视图
-- 创建用户订单汇总视图\nCREATE VIEW user_order_summary AS\nSELECT\n u.id,\n u.name,\n u.email,\n COUNT(o.order_id) AS total_orders,\n COALESCE(SUM(o.amount), 0) AS total_amount,\n MAX(o.creat