Amazon
Amazon Data Analyst Interview Questions
Amazon is one of the FAANG companies, and its data analyst interviews lean on joins, ranking and conditional logic. These questions cover the same ground, in SQL, pandas and Python.
Start solving and check your level of preparation.
The questions
- First unique characterPythonStringseasy
- Large orders with customer namesSQLJoinseasy
- Price bandsSQLConditional logiceasy
- Products with no brandSQLNULL handlingeasy
- Revenue by categoryPandasAggregationseasy
- Stock statusSQLConditional logiceasy
- Customers without ordersSQLJoinsmedium
- Flatten a category treePythonListsmedium
- Hours between scansSQLWindow functionsmedium
- Orders from enterprise customersSQLSubqueriesmedium
- Orders per customer segmentSQLJoinsmedium
- Packages still movingSQLRankingmedium
- Prime vs. standard order valueSQLJoinsmedium
- Revenue by statePandasJoinsmedium
- Stage times per packageSQLReshapingmedium
- The busiest customerSQLSubqueriesmedium
- Averages that skip NULLsSQLNULL handlinghard
- Largest order per customerPandasRankinghard
- Slowest package per facilitySQLRankinghard
- Top spending customersSQLJoinshard
Questions last reviewed 19 October 2026.
