SQL · Robinhood · Hard
Requirements SQL. Work with these two tables: user_info(id, shard, name, country, state, created_date) — shard identifies a partition, so any join must use both id and shard. user_info_edit_log(id, shard, created_date, table_name, field_name, old_value, new_value) — restrict the log entries to table_name = user_info and field_name = state. Return (id, shard, name) for each of the following groups: Q1: Users whose state has always been CA through 2021-01-01. Q2: Users who…
Checking your access…