SQL · Capital One · Hard
A subscription system failed to record premium signups between 2025-01-01 and 2025-03-31, inclusive. The table premium_intended_enrollments stores when each user wanted to start, while premium_actual_registrations stores the date the registration was later written. Members are billed 10 dollars per month in arrears only after their registration exists. For a user whose intended_start_date is not after the outage end, count a calendar month within the outage as lost if the…
Checking your access…