View with join for reporting
SQL
Medium
0 views
Problem Description
Create v_order_summary showing order_id, customer_name, total_amount, order_date.
Output Format
View created
Official Solution
CREATE VIEW v_order_summary AS SELECT o.order_id, c.name AS customer_name, o.total_amount, o.order_date FROM Orders o JOIN Customers c ON c.customer_id = o.customer_id;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!