This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Engineer at Hulu. The downstream reporting pipeline requires that every subscription row has a valid end_date value. Currently, ongoing subscriptions have a missing (NULL) end_date. Your task is to fill those missing values with a far-future sentinel date 2099-12-31 and add a boolean flag column so analysts can easily tell which subscriptions are still ongoing.
You are a Data Engineer at Hulu. The downstream reporting pipeline requires that every subscription row has a valid end_date value. Currently, ongoing subscriptions have a missing (NULL) end_date. Your task is to fill those missing values with a far-future sentinel date 2099-12-31 and add a boolean flag column so analysts can easily tell which subscriptions are still ongoing.