Level 5 - SeniorQuery-Based Questions
Safe Add NOT NULL Column with Backfill
Interviewer prompt: A hot table users(20M rows) needs a new column timezone NOT NULL, default 'UTC', with minimal risk. Write migration SQL in safe order.
Schema Context
users(user_id, email, created_at)