Amazon·Data Analyst·Technical Phone Screen
Jun 2026
Amazon SQL/analytics question, pretty much just one problem about finding top customers per year. Short and uneventful.
- Given a table of customer orders, write a query to find the top customer (by total order value or count) for each year.
“Pretty standard window function problem.”