This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Junior Data Analyst at Citibank. The data engineering team is building a reporting pipeline that requires every account to have a closed_at date. Accounts that are still open have a NULL value in this column. Your task is to fill all missing closed_at values with the sentinel date '9999-12-31' so downstream systems can treat every row uniformly without null-checking logic.
You are a Junior Data Analyst at Citibank. The data engineering team is building a reporting pipeline that requires every account to have a closed_at date. Accounts that are still open have a NULL value in this column. Your task is to fill all missing closed_at values with the sentinel date '9999-12-31' so downstream systems can treat every row uniformly without null-checking logic.