Materialized View for Monthly KPIs

Interviewer prompt: Finance needs fast month-level paid revenue and order count. Write PostgreSQL SQL to create and index a materialized view.

orders(order_id, order_ts, status, total_amount)