Aggregating Data by Month Overlapping Entities with PostgreSQL

Mastering SCD Type-2 Tables: How to Update Granularity without Compromising Data Integrity