Interview Guides

Interview Guides

Detect Overlapping Subscription Periods | Dataford Interview Questions

All questions/SQL & Data Manipulation

Detect Overlapping Subscription Periods

Hard

Window FunctionsDate FunctionsSelf-Joins

Problem

Task

You are given subscription records for customer accounts. Write a PostgreSQL query that identifies every pair of subscriptions for the same account whose active date ranges overlap, including cases where one subscription starts on the same day another ends. Return the account, both subscription IDs, and the overlapping date range.

Problem

Task

You are given subscription records for customer accounts. Write a PostgreSQL query that identifies every pair of subscriptions for the same account whose active date ranges overlap, including cases where one subscription starts on the same day another ends. Return the account, both subscription IDs, and the overlapping date range.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Qantas

Track Monthly Customer Activity ChangesHard

Chewy

Active Subscription Revenue by CustomerHard

ABB

Detect Financial Trends by MonthMedium