California Residency SQL / Data Query Problems

Problem Overview

You are given two tables: 1. user_info (id, shard, name, state, …) — current user profile. The join key is the composite (id, shard). 2. user_info_edit_log (id, shard, created_date, table_name, field_name, old_value, new_value) — audit log of field changes. For this problem, only consider rows where table_name = 'user_info' and…

• 4 candidate-reported follow-ups — the exact probes interviewers asked, with the trigger for each
• The rest of the problem statement — full requirements, constraints, and edge cases
• Approach and trade-offs — what passing candidates did, and the mistakes that sink people