Keep summary table in sync
SQL
Medium
0 views
Problem Description
Maintain DailySales(day, amount). After insert into Orders, update DailySales for that date.
Output Format
Trigger created
Sample Test Case
Input:
Orders, DailySales
Constraints
Use upsert style update+insert
Official Solution
CREATE TRIGGER trg_daily_sales AFTER INSERT ON Orders FOR EACH ROW BEGIN UPDATE DailySales SET amount = amount + NEW.total_amount WHERE day = NEW.order_date; IF ROW_COUNT() = 0 THEN INSERT INTO DailySales(day, amount) VALUES (NEW.order_date, NEW.total_amount); END IF; END;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!