Ohm Analytics interview question

Advance lookups to clean data