Procedure to rebuild summary table
SQL
Medium
2 views
Problem Description
Create sp_refresh_daily_sales that truncates DailySales and re-inserts aggregated totals from Orders.
Input Format
SQL procedure
Output Format
Procedure created
Sample Test Case
Input:
DailySales(day, amount), Orders(order_date, total_amount)
Output:
Procedure created
Constraints
Use TRUNCATE + INSERT SELECT
Official Solution
CREATE PROCEDURE sp_refresh_daily_sales() BEGIN TRUNCATE TABLE DailySales; INSERT INTO DailySales(day, amount) SELECT order_date, SUM(total_amount) FROM Orders GROUP BY order_date; END;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!