Quick Overview

This question evaluates proficiency in data manipulation and analytical querying with SQL/Python, emphasizing date-based windowing, join operations, aggregation to identify maxima, and handling tied results.

Find top buyer in earliest 10-year window

Company: Wayfair

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Online Assessment

Overview: This question evaluates proficiency in data manipulation and analytical querying with SQL/Python, emphasizing date-based windowing, join operations, aggregation to identify maxima, and handling tied results.

Loading…