Creating Date Ranges from Multiple Rows Based on a Single Date

How to Join Date Ranges in Your Select Statement Using an Ad-Hoc Tally Table Approach

Querying Date Ranges in PostgreSQL Using the Containment Operator