Wayfair·Data Scientist·Online Assessment (OA)
- Given a customers table and a purchases table, write a SQL query to find the customer(s) with the highest purchase price within the earliest 10-year window of purchase history. Return all tied customers if applicable.
- Write a Python function using pandas that cleans a student scores DataFrame by dropping students missing two or more scores, imputing remaining nulls with per-column medians, then returning the top 5 students sorted by math score descending, physics score descending, and student ID ascending.
“The 10-year window thing tripped me up.”