California Residency History SQL
Robinhood interview questions · Hard · OA round · reported 1× · written walkthrough
Rebuild what a user's state was at a given moment from today's snapshot plus a log of edits, then answer CA-residency questions over time while being precise about whether timestamp boundaries are inclusive.
The full question, tests and reference solution are available with a plan that includes Robinhood.
Run your code with Ctrl+Enter to see results.