Procedure to rebuild summary table

Procedure to rebuild summary table

Medium SQL Stored Procedures 18 views
Explanation Complexity

Problem Statement

Create sp_refresh_daily_sales that truncates DailySales and re-inserts aggregated totals from Orders.

Input Format

SQL procedure

Output Format

Procedure created

Example

DailySales(day, amount), Orders(order_date, total_amount)
Procedure created

Constraints

Use TRUNCATE + INSERT SELECT

Input / Output Format

Input Format
SQL procedure
Output Format
Procedure created
Constraints
Use TRUNCATE + INSERT SELECT

Examples

Input:
DailySales(day, amount), Orders(order_date, total_amount)
Output:
Procedure created

Example Solution (Public)

SQL 
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;

Official Solution Code

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;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.