Build Rollup Table for Dashboard

Interviewer prompt: Dashboard needs daily revenue by region with low latency. Write SQL to create rollup table and populate it from orders.

orders(order_id, region, order_date, total_amount, status)